SQL Server 2016 SP1 CU9: Sophie’s Cumulative Update

SQL Server 2016 Service Pack 2 came out last month, so if you were going to update 2016 today, you were probably planning on applying SP2.

But lemme throw a strange monkey wrench in the works: Microsoft just released Service Pack 1 Cumulative Update 9, and it has fixes that aren’t in Service Pack 2, like:

• PFS page round robin algorithm improvement
• Fixed PAGELATCH_EX and PAGELATCH_SH waits in TempDB
• Change tracking is inconsistent during an update on a table with a clustered index
• TDE database goes offline during a log flush

So right now, you have just a little bit of a problem: you have to pick which of those two updates has more fixes that are relevant to your own needs. Or, you can hang tight for another week or two, and most likely we’ll see a cumulative update for SP2.

Update: good news! Just like that, they also released 2016 SP2 CU1.