Boost Your SQL Server Performance with the Latest Cumulative Updates: SQL Server 2017 CU18 and SQL Server 2016 SP2 CU11
Microsoft has released two new cumulative updates for SQL Server 2017 and SQL Server 2016 Service Pack 2. These updates include several bug fixes and performance improvements, so it’s essential to install them to ensure your system is running smoothly and efficiently.
SQL Server 2017 CU18 includes a range of bug fixes, including support for snapshot and transactional replication on Linux, fixing deadlocks caused by concurrent inserts into a clustered columnstore index, and resolving an access violation when restoring an In-Memory OLTP database. It also addresses issues related to orphaned CLR sessions causing blocking, update stats taking a long time to build a query plan, and access violations on adaptive joins.
SQL Server 2016 SP2 CU11 includes many of the same fixes as SQL Server 2017 CU18, as well as some additional improvements. This includes fixing a self-deadlock issue when auditing is enabled, resolving non-yielding scheduler issues related to parallel batch-mode sort operators, and fixing a memory leak on partitioned tables. Additionally, it addresses issues related to non-yielding schedulers caused by processing large numbers of row-column values in row groups.
These updates include many more fixes, so be sure to check out the full list of improvements in the KB article. It’s recommended to install these updates in your dev and staging environments and then roll them out over the holidays when everyone’s out of the office.
For more information on SQL Server 2017 CU18, visit Microsoft’s site here: https://support.microsoft.com/en-us/topic/cumulative-update-18-for-sql-server-2017-9baf1e8a-47d1-c87c-1bc5-52c8d15d99a9. For more information on SQL Server 2016 SP2 CU11, visit Microsoft’s site here: https://support.microsoft.com/en-us/topic/cumulative-update-11-for-sql-server-2016-sp2-8dd3c68e-6605-5b5d-30a6-989d7efb346f.
It’s recommended to keep your SQL Server system up to date with the latest patches and updates to ensure your data is secure and your system is running at its best.