KB5039747 - Cumulative Update 28 for SQL Server 2019

KB5039747 - Cumulative Update 28 for SQL Server 2019

Improvements and fixes included in this update

3305037
Digitally signs the Intel Threading Building Blocks (Intel TBB) assemblies by using a Microsoft certificate.

3217207
Starting with SQL Server 2019 (15.x) CU28, container images include the new mssql-tools18 package. The previous directory /opt/mssql-tools/bin is phased out. The new directory for Microsoft ODBC 18 tools is /opt/mssql-tools18/bin, aligning with the latest tools offering. For more information about changes and security enhancements, see ODBC Driver 18.0 for SQL Server Released.

3278707
Fixes the following error that you encounter during a Volume Shadow Copy Service (VSS) restore on a SQL Server instance that has previously deleted databases:

Volume Shadow Copy Service error: Unexpected error calling routine GetVolumePathName is fail on the path <pathname> ... The system cannot find the file specified.

3285766
Fixes an issue in which the SQL Server Launchpad service can't shut down properly when certain errors occur during startup.

3323675
Fixes a latch time-out issue that you encounter when fetching the next value for sequence objects, which is due to self-deadlock during lock escalation.

3296380
Fixes an issue in which PolyBase throws the following error at service startup if the SQL Server instance is configured to listen on multiple TCP ports:

System.ArgumentException: Unable to parse port, instance = '<instancename>', text = '<text>'

3312936
Fixes a non-yielding scheduler dump issue that you might encounter when forcing a query plan in the Query Store (QDS).

3312950
Fixes an issue in which error 18752 occurs and transactional replication stops working when you use a heavy workload in combination with availability groups and after a failover occurs.

Error message:

Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection with session ID <sessionid> over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure.

3338718
Fixes the following error 21890 that you encounter when you use the case-sensitive collation and run sp_validate_redirected_publisher:

The SQL Server instance '<instancename>' with distributor '<distributorname>' and distribution database '<databasename>' cannot be used with publisher database '<databasename>'. Reconfigure the publisher to make use of distributor '<distributorname>' and distribution database

3020820
Fixes an out of memory issue that you encounter when running a stored procedure on a remote SQL Server instance by using a linked server.

3312461
Increases the threshold of the following log message when high I/O latencies are detected in Bufferpool Lazy Writer (ntdll!ZwWriteFile system call) due to a performance issue in the underlying storage:
WARNING Long asynchronous API Call: The scheduling fairness of scheduler can be impacted by an asynchronous API invocation unexpectedly exceeding xxx ms.
The SQL Server error log might be filled by excessive logging of the log message.