Enhance Your SQL Server 2016 Performance and Security with Cumulative Update 9 – HOLD

Hold off on this update for now. The updated KB notes:

There is an uninstall issue with SQL16 SP2 CU9. The payload in CU9 is fine, but if you have not already installed CU9, it is recommended that you wait for the upcoming expedited SQL16 SP2 CU10 release.

Microsoft has released Cumulative Update 9 for SQL Server 2016 Service Pack 2, which addresses several issues that users have reported. This update includes a range of bug fixes and performance improvements, so it’s recommended to install it as soon as possible to ensure your system is running smoothly and efficiently.

Some of the issues that have been fixed in this update include the transaction log not being truncated in a single-node AG, an access violation for PIVOT or UNPIVOT, and incorrect results with partitioned clustered columnstore indexes. There was also an issue where an access violation occurred when restoring an In-Memory OLTP database, which has now been fixed. Additionally, Frozen IO won’t resume after backing up a database with In-Memory OLTP, which has also been addressed in this update.

Another issue that has been fixed is related to Availability Groups direct seeding. This issue was causing frustration for users, but with the latest update, Availability Groups direct seeding can stop and start as expected.

Another fix that many users will appreciate is related to sys.database_scoped_configurations. This fix means that the sp_Blitz check for non-default database scoped configs will finally work as expected, returning the correct results.

Better cardinality estimation is also included in this update. This will improve query performance and help ensure that you’re getting accurate results from your queries.

For those of you planning patch windows, it’s also been 60 days since the last 2017 CU, so you can expect another update to drop soon.

It’s recommended to keep your SQL Server 2016 system up to date with the latest patches and updates to ensure your data is secure and your system is running at its best. For more information on Cumulative Update 9 for SQL Server 2016 Service Pack 2, visit Microsoft’s site here: https://support.microsoft.com/en-us/topic/cumulative-update-9-for-sql-server-2016-sp2-07aa6c09-6d20-6ce2-40a5-891f7e361fd5.