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 2017 CU15, SQL Server 2016 SP2 CU7

4 years ago
Brent Ozar
SQL Server 2016, SQL Server 2017, Updates

This week, Microsoft released two pretty big updates.

SQL Server 2016 SP2 CU7 has a ton of fixes including:

  • Filtered index corruption
  • Access violations in sys.dm_exec_query_statistics_xml, sys.dm_hadr_availability_replica_states, sys.availability_replicas, sys.dm_db_xtp_hash_index_stats, sys.fn_dump_dblog, sys.dm_db_xtp_checkpoint_files (translation: if you monitor your servers, you should probably apply this CU to avoid problems caused by the monitoring tool’s queries)
  • AG failover fails
  • Incorrect query results on columnstore indexes, and also this

SQL Server 2017 CU 15 has even MORE fixes, and you owe it to yourself to read the full list.

There are some CUs you might be tempted to skip because they don’t affect you. I don’t think this week’s releases fall into that category – there are a wide, wide range of features affected by this week’s patches.

Update May 28: CU15 introduced a bug in Availability Groups. Queries of sys.fn_hadr_backup_is_preferred_replica will fail, which can cause your backups not to work. The workaround is to do your backups with another method (like manually calling the backup commands rather than using maintenance plans or Ola Hallengren’s scripts), or avoid CU15.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Security Update for SQL Server 2017 Analysis Services
Next Post
Announcing a Tall Refreshing SQL Server 2014 Cumulative Update

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