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 has admitted that a recent update can stop database connections from closing properly after certain queries. Over time these open connections can slow the server down, and the only quick fixes are to close them by hand or restart the service, which can interrupt work in progress.
Like I’m new · 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