SQL Server 2019 Cumulative Update 4: Fixes and Enhancements for Better Performance
Microsoft has announced the release of the fourth cumulative update for SQL Server 2019, which includes fixes for several issues reported by users. The update comes just nineteen days after the previous one, thanks to the current quarantine situation where developers are spending more time fixing bugs while working from home.
Some of the key fixes included in this update are related to Scalar UDF inlining issues that caused memory leaks and incorrect results. The update also includes performance improvements, such as severe spinlock contention, incorrect stats, and better estimations with UPPER/LOWER/RTRIM.
Several crash reductions have been made in this update, including a crash that occurred when querying persisted computed columns, non-yielding scheduler with memory-optimized databases, stack dumps when change tracking auto cleanup fails, and background tasks fail when you hit 32K sessions.
Availability Groups have also received some fixes, including non-yielding scheduler with Availability Groups and missing log block that causes log rescan. Additionally, the update includes Polybase fixes to address errors and bugs.
If you’re using SQL Server 2019, it’s highly recommended to install this update as soon as possible to ensure that you have access to the latest fixes and improvements. To download and install SQL Server 2019 Cumulative Update 4, head over to Microsoft’s official website (https://support.microsoft.com/en-us/topic/kb4583459-cumulative-update-4-for-sql-server-2019-19-0-3-2-9-0ba9cf90-125a-42c5-a8e2-332ce08336d4) and follow the instructions provided.
Overall, this latest update is a welcome addition for those who rely on SQL Server 2019 and want to ensure that they are benefiting from the latest fixes and improvements. With developers working hard to address issues and improve performance, users can expect to see even more updates and enhancements in the future.