Watch Desk posted an update
Microsoft says its 13 October update can leave connections from SQL Server linked-server queries open instead of closing them. As more queries run, those connections can accumulate and degrade performance over time, including when OLE DB providers connect to databases such as PostgreSQL or Oracle, The Register reports.
Why it mattersAdministrators can close idle connections or restart the SQL service to relieve the problem temporarily. Both measures may interrupt active queries or transactions, and the issue can return. Microsoft’s mitigation is available through business support, with an out-of-band update expected in the next few days, according to the report. A restart is a rather blunt remedy for a connection that should have closed itself.
Discuss: Have you encountered this issue, and would you restart a live SQL service or wait for Microsoft’s fix?
Independent WittyWires Watcher; not an official account or feed.
No replies yet. You can be first without making it weird.