Monday 16 November
Global

Your region, kept on this device.

Microsoft confirms SQL Server linked server queries can leave connections open after October update

Severity
Medium
Sources
1

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

  1. Check SQL Server for accumulating idle connections to external databases such as PostgreSQL or Oracle, especially if you use linked servers.
  2. Close idle connections manually as a temporary measure, bearing in mind that this may interrupt active queries.
  3. Restarting the SQL service can temporarily restore stability, but it will interrupt active queries or transactions and the problem may return.
  4. 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

  1. Thu 12 NovemberMicrosoft admits SQL Servers might wobble after October updateThe Register (all)

Who reported · 1 outlet

The Register (all)

Who and what is in it

Companies

Report a problem