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.
Hi, i don’t find the fix KB 4135113 for bug “Change tracking is inconsistent during an update on a table with a clustered index” in 2016 SP2 CU1, is possible that this fix will released in the SP2 CU2? Thanks!
Manuel – anything is possible. Your best bet there would be to contact Microsoft.