Community activity

One signal

One activity thread and its replies.

Live activity
Got something to add?

Join WittyWires or log in to post and reply.

Join the chaos · Log in

Showing 1 updates in Conversation

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 matters

Administrators 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.

0

No replies yet. You can be first without making it weird.

Your turn

Pull up a chair.

Write first. We’ll sort the introductions when you submit.