Menu

1 / 3

Microsoft admits SQL Servers might wobble after October update

Reading 0:00
15s threshold

databases

Linked server connections can linger long past their welcome

Encountered some odd SQL Server connection behavior since the October update? There might be a culprit… Microsoft has admitted that a change has caused linked server queries to fail to close connections.

Linked servers via OLE DB providers have been around for years and are a useful way of, for example, using additional data sources in queries. Once a provider is added, SQL Server can open a connection to grab data, and close it again when the query is complete. Or, at least, that's the theory.

The problem is that after the October 13 (KB5126646) update, connections created by SQL Server linked server queries might remain open. According to Microsoft, "As additional queries are performed, connections to external databases can accumulate instead of closing as expected.

"This can slow or degrade server performance after prolonged run time."

You think?…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.