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?…