Technology news and discussion on TalkFuse.
October update leaves SQL Server linked database connections open
Microsoft says its 13 October update, KB5126646, can leave connections open after SQL Server linked server queries finish. As those connections build up, server performance can slow or degrade, potentially affecting systems that use external databases.
The issue affects linked server queries using OLE DB providers, with PostgreSQL and Oracle among the examples Microsoft cites. Administrators can close idle connections or restart the SQL service temporarily, though either action may interrupt active work and the problem can return. Microsoft offers a mitigation through business support and says an out-of-band update is expected within days; affected Windows versions range from Windows 10 1809 and Windows Server 2012 up to Windows 11 25H2 and Windows Server 2025.
In short
- An October update can leave SQL Server linked database connections open.
- Accumulating connections may degrade performance over time.
- Microsoft says a fix is expected within days.
Explained simply
SQL Server is Microsoft’s software for storing and managing data. Organisations can use linked servers to let it query databases held in other systems, including PostgreSQL and Oracle, through software called OLE DB providers.
These links are used when applications need to work with data from more than one database. If connections stay open after queries finish, they can accumulate and use up server resources, which may slow systems that depend on them.
Read the full article at the source →
Originally published by The Register as “Microsoft admits SQL Servers might wobble after October update”.