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

This Week’s Power App: SQL Server 2016 SP2 CU2, SP1 CU10

5 years ago
Brent Ozar
SQL Server 2016, Updates
1 Comment

After a brief yatus (that’s a Big Brother joke for the other 3 of you out there watching this season, who will now also get the reference in the title – you’re welcome – the rest of you are in for a very confusing post), Microsoft released the next round of patches.

Fixes and improvements include:

  • DAG improvement – automatically seed replicas – when you add a database to an existing AG, SQL Server can automatically seed it across the secondary replicas. I know a lot of SaaS companies who will get excited about these new Swaggy AGs.
  • AGs – configurable session_timeouts
  • AGs – slow transactions with 1 sync and 1 async secondary
  • AGs – on cross-data-center AG failover, you get a non-yielding scheduler and a crash (not much details in this one, so Bayleigh probably secretly took the primary nominations off the block)
  • AGs – queries on secondary take twice as long (absolutely no details on root cause here either, like Microsoft is trying to backdoor us)
  • AGs – VSS backups fail on secondary replicas in a Basic Availability Group (which technically you’re not supposed to do, but you can still back up the entire secondary VM, and that’s where the problem looks like it’s coming in)
  • AGs – fixing error 19432 for duplicate log blocks
  • Log shipping – add support for Transparent Data Encryption by configuring MAXTRANSFERSIZE.
  • Dynamic data masking doesn’t
  • SSAS crashes when Process Full follows Process Clear – I love the line “you will notice that the SSAS may crash.” Zingbot is writing KB articles now.
  • Memory dump when you merge partitioned temporal tables – basically, when you take someone off the block.
  • Stats updates can get a “corrupted index” message and a disconnect
  • Assertion error when you add a database
  • Slow performance when Query Store is enabled
  • Non-yielding schedulers require a reboot – quite possibly the least informative KB article ever. “Assume that you have a Microsoft SQL Server 2016 installed.” Hoo boy. Someone needs to spend a little more time in the Diary Room.

And there’s more listed in their KB articles. The downloads are arriving at your doorstep now via Hamazon Swine (last Big Brother joke today, we promise) or you can download SQL 2016 SP2 CU2 and/or SP1 CU10. For the record, I’m rooting for Faysal and Sam.

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 8 (Update: Food Edition)
Next Post
Announcing SQL Server 2017 Cumulative Update 9

1 Comment. Leave new

  • A Day in the Life of Brent Ozar: July 17, 2018 #SQLCareer – Brent Ozar
    July 18, 2018 1:33 pm

    […] 4:45-6:45 – Learning. Read the blogs from overnight – in addition to the 362 SQL Server blogs I subscribe to (OPML – Feedly), I also read HackerNews and a lot of non-technical stuff. I tend to bookmark the very best (or most interesting) stuff on my Pinboard feed, and some of those end up in our Monday newsletters. Microsoft published a couple of cumulative updates, so I post them on SQLServerUpdates.com. […]

    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