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

Announcing SQL Server 2016 SP2 CU5, SP1 CU13

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

Microsoft went on holiday vacation, and they came back with a vengeance. There are one heck of a lot of fixes inside SP2 CU5 and SP1 CU13, including:

  • Access violation when you compile a query
  • Access violations and unhandled exceptions with Always On Availability Groups automatic seeding
  • Dynamic Data Masking doesn’t when there’s a cursor involved
  • Access violations for XML data types
  • Query Store blocks transactions and log truncation
  • Out of memory errors
  • Non-yielding schedulers with heavy use of prepared statements
  • Can’t restore compressed backups of encrypted databases
  • High CPU usage when there are many batch requests (uh, duh)
  • SQL Server service crashes when you cancel CHECKDB (on a “large database”, whatever the hell that is)

I could go on and on – there are a LOT of fixes in here. Go check out SP2 CU5 and SP1 CU13.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing SQL 2017 CU13, 2014 SP3 CU1, SSMS 18.0 P6, OMG, BBQ
Next Post
Announcing SQL Server 2014 SP3 CU2 and SP2 CU16

2 Comments. Leave new

  • Dave Dustin
    January 23, 2019 9:18 pm

    The BPE one is really nasty because SQL Server is still “running”, it’s just not doing anything. And 9 times out of 10, it halts in such a way that AG failovers don’t occur, so you’re stuck with sync secondaries in an unusable state.

    You can’t stop/start the service, you have to bounce the box, at which point the AGs all fail over.

    Reply
  • john chendorain
    January 24, 2019 9:26 pm

    I am going to bed tonight and wake up tomorrow and I will download 2016 SP2 CU 6 instead, thx

    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

  • 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
  • Announcing SQL Server 2017 Cumulative Update 25: The Silver Anniversary July 12, 2021
  • Announcing SQL Server 2019 Cumulative Update 11: This One Goes to … June 11, 2021

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