Introduction
Microsoft has acknowledged that recent Windows updates are causing performance and stability issues with SQL Server, particularly affecting linked server queries that use OLE DB providers to connect to external databases. This article delves into the specifics of the issue, including its impact and potential solutions.
Detailed Analysis
Cause of the Issue
The issue stems from server queries that leave connections open after completing. These connections accumulate over time, leading to degraded server performance. This problem is specifically tied to SQL Server linked server queries that utilize OLE DB providers for external database connections, including Oracle and PostgreSQL.
Affected Systems
The issue impacts both client (Windows 10 and Windows 11) and server (Windows Server 2012 and later) systems. Microsoft plans to address the issue with an out-of-band Windows update.
Mitigation Strategies
Administrators can manually close connections left open by this bug or restart the SQL service to temporarily address stability and performance issues. However, these solutions may not fully resolve the issue, as it will recur after some time.
Additional Information
Microsoft has also addressed other recent issues, such as memory management changes affecting SQL Server crash dumps, and security updates causing deployment failures on Windows 11 systems. The company is working to resolve the SQL Server issue and provide a fix in the near future.
Conclusion
While Microsoft is working on a resolution, administrators can reach out to Microsoft Support for Business for a temporary mitigation until a fix is available. The issue affects both client and server systems, impacting a wide range of environments and services.
Comments