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

says the October 13 update (KB5126646) causes linked server queries using OLE DB providers to leave connections to external databases open instead of closing them, with 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

  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