SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

SQL Server 2016 SP1 CU9: Sophie’s Cumulative Update

5 years ago
Brent Ozar
SQL Server 2016, Updates
2 Comments

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.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing SQL Server 2017 Cumulative Update 7
Next Post
Announcing SQL Server 2014 SP2 Cumulative Update 12

2 Comments. Leave new

  • Manuel
    June 11, 2018 9:51 am

    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!

    Reply
    • Brent Ozar
      June 11, 2018 10:16 am

      Manuel – anything is possible. Your best bet there would be to contact Microsoft.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021
  • Announcing 2016 Service Pack 3 and 2017 CU26 September 15, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy