Microsoft has now released SQL Server 2016 SP2 CU10 as a replacement for SP2 CU9 (and they have removed SP2 CU9 from the build list). This happened not because of any problems with the actual SP2 CU9 payload (the binaries), but because of a problem if you tried to uninstall SP2 CU9. Here is the Microsoft statement about the issue:
SQL Server 2016 SP2 CU10 is a replacement for SQL Server 2016 SP2 CU9. CU9 had an uninstall issue that is resolved in the CU10 package. If you previously installed CU9, we recommend that you install CU10.
In my experience, it is not that common to want to (or have to) uninstall a SQL Server CU, but it does occasionally happen. Even so, the uninstall process should work as advertised, and it is unfortunate that this issue wasn’t caught before it was released.
Microsoft has released SQL Server 2016 SP2 CU9, which is Build 13.0.5470.0. This cumulative update has 21 public hotfixes. Keep in mind that both the SQL Server 2016 RTM and SQL Server 2016 SP1 branches are out of support, so there won’t be any more cumulative updates for those branches.
This is one of the more interesting fixes:
FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi column statistics
If you haven’t done it already, you should be making plans to get on the SP2 branch of SQL Server 2016. The Microsoft SQL Server 2016 build versions list is here.
4 thoughts on “SQL Server 2016 SP2 CU9 Released”
It is already replaced by CU10 because of uninstall issues:
That is correct. Thanks for the info.
It looks like they’ve already released a CU10 because of an issue with the CU9 installer.
Yes, that is correct. Thanks for the heads up!