Microsoft confirms SQL Server linked server queries can leave connections open after October update
PATCHMicrosoftredteam/daily · 1 source
- Severity
- Medium
- Sources
- 1
What happened
Microsoft says the October 13 update (KB5126646) causes SQL Server linked server queries using OLE DB providers to leave connections to external databases open instead of closing them, with PostgreSQL and Oracle cited as examples. This can degrade performance over prolonged run time. Workarounds are manually closing idle connections or restarting the SQL service, which may interrupt active queries; a mitigation is available through Microsoft support for business, and an out-of-band update is expected within days.
For IT people · Written by AI from 1 source · Wrong?
What to do
- Check SQL Server for accumulating idle connections to external databases such as PostgreSQL or Oracle, especially if you use linked servers.
- Close idle connections manually as a temporary measure, bearing in mind that this may interrupt active queries.
- Restarting the SQL service can temporarily restore stability, but it will interrupt active queries or transactions and the problem may return.
- Contact Microsoft support for business for the available mitigation and watch for the out-of-band update expected within days.
Written by AI from the sources, checked against them
Full story timeline · 1 update
Who reported · 1 outlet
The Register (all)
Who and what is in it
Companies
Products