Cumulative Update 6 for SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

This article describes cumulative update package 6 (build number: 13.0.2204.0) for Microsoft SQL Server 2016. This update contains fixes that were released after the release of SQL Server 2016.

Cumulative update

Cumulative updates (CU) are now available at the Microsoft Download Center.

Only the most recent CU that was released for SQL Server 2016 is available at the Download Center.

  • Each new CU contains all the fixes that were included with the previous CU for the installed version/Service Pack of SQL Server.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available:

    • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.

  • Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2016 service pack.

How to obtain this cumulative update package


The following update is available from the Microsoft Download Center:


If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note After future cumulative updates are released for SQL Server 2016, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.

Hotfixes that are included in this cumulative update package


 
VSTS bug number KB article number Description Fix area Status
9917140 4019903 FIX: Query against sys.dm_db_partition_stats DMV is slow if the database contains many partitions in SQL Server 2016 SQL service
9902335 4019893 FIX: Restore fails when you do backup with compression and checksum on TDE enabled database in SQL Server 2016 SQL service
9813852 3210089 GDR update package for SQL Server 2016 SP1 Reporting Services
9813828 4013111 FIX: DMV sys.dm_hadr_availability_group_states displays "NOT_HEALTHY" in synchronization_health_desc column on secondary replicas in SQL Server High Availability
9813857 4014798 Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server SQL service
9720331 4016850 FIX: You receive incorrect results when you use SQL Server Management Objects to generate a script for a full-text Search index Management Tools
9642869 4016946 FIX: Deadlock when you use sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats DMV with large DDL operations in SQL Server 2016 SQL service
9813835 4014756 FIX: SQL Server Profiler fails to obfuscate sp_setapprole when it's executed from a remote procedure call in SQL Server SQL service
9808882 4013999 FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2016 SQL service
9901863 4019701 FIX: Database schema is corrupted when you restore a database from a snapshot in SQL Server SQL service
9627365 4016945 FIX: "The custom resolver for this article requires OLEAUT32.DLL with a minimum version of 2.40.4276" error with merge publication in SQL Server SQL service
9813867 4014738 FIX: Error occurs when you drop a subscription by using a non-sysadmin account in SQL Server SQL service
9822981 4017154 Intra-query deadlock on communication buffer when you run a bulk load against a clustered columnstore index in SQL Server 2016 SQL performance
9813871 4013208 FIX: "Partition cannot contain column segments of different data versions" error when you process data on a partition in SSAS Tabular model Analysis Services
9906184 4019671 FIX: A severe error occurs when you create a spatial index with the GEOMETRY_GRID or GEOGRAPHY_GRID option in SQL Server SQL service
9813824 4014732 FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server SQL service
9875181 4019048 FIX: SSAS crashes when you retrieve KPIs as hidden members by using schema rowsets in SQL Server Analysis Services
9813861 4014706 FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server SQL service
9719215 4016361 FIX: Service Broker endpoint connections aren't closed after an availability group failover in SQL Server SQL service
9877136 4019840 FIX: Queries against PolyBase external tables return incorrect results in SQL Server 2016 SQL service
9917205 4019863 FIX: An assertion occurs when you execute an ALTER TABLE SWITCH statement on a partitioned temporal history table in SQL Server 2016 SQL service
9901010 4019446 FIX: SQL Server 2016 stops responding when the "Latch_Suspend_End" extended event is triggered incorrectly SQL performance

Notes for this update


Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the hotfixes:

Cumulative update package information


Prerequisites

To apply this cumulative update package, you must be running SQL Server 2016.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.