Science & Tech · Big Tech & Internet · 1 hr ago

Windows updates cause SQL Server performance and stability problems

Windows updates cause SQL Server performance and stability problems

Microsoft says Windows updates released since October’s Patch Tuesday are affecting SQL Server on Windows client and server systems.

The bug affects linked server queries that use OLE DB providers to connect SQL Server to external databases, including Oracle and PostgreSQL.

Some queries leave database connections open after they finish, and the connections build up over time.

This can reduce server performance and cause stability problems for organizations that rely on these systems.

Administrators can close lingering connections or restart the SQL service, but these steps may interrupt active queries and the problem can return.

Microsoft plans to release an out-of-band update in the coming days and says administrators can contact Microsoft Support for Business for a temporary mitigation.

2 sources

Related

What people are saying

Microsoftsoftware company
This issue affects SQL Server linked server queries that use OLE DB providers to connect to external databases. Oracle and PostgreSQL connections are among those known to be affected.
via BleepingComputer
In affected environments, administrators might observe an increasing number of open connections to external databases, even when the associated SQL Server linked server queries are no longer running.
via BleepingComputer