Cumulative Update 10 for SQL Server 2016 SP2

Gilt für: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

This article describes Cumulative Update package 10 (CU10) (build number: 13.0.5492.2) for Microsoft SQL Server 2016 Service Pack 2 (SP2). This update contains fixes that were released after the initial release of SQL Server 2016 SP2.

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 SP2 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, we recommend that you always install the latest cumulative update that is available.

Additional hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area
13113745 4513096 FIX: Repair fails for Machine Learning components on server with no Internet access Setup & Install
13077821 4515772 FIX: Transaction log isn‘t truncated on a single node Availability Group in SQL Server 2016 High Availability
13105506 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server 2016 SQL Engine
13122059 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016 SQL Engine
13130364 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server 2016 SQL performance
13098936 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server SQL Engine
13076524 4519679 FIX: Different users get the same model list with different permissions in SQL Server 2016 Data Quality Services (DQS)
13138952 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016 SQL Engine
13140478 4519847 FIX: MDS Configuration Manager reports SP2 base version in SQL Server 2016 Setup & Install
13069180 4520109 FIX: Access violation occurs when you restore In-Memory OLTP database in SQL Server 2016 In-Memory OLTP
13086240 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol SQL Engine
13122073 4520266 FIX: When you change SEEDING_MODE to MANUAL using ALTER AVAILABILITY GROUP, SQL Server 2016 does not cancel the current seeding operations to the secondary replica High Availability
13056235 4520739 FIX: Access violation error occurs when you try to insert results of stored procedure into a table with dynamic data masking in SQL Server 2016 SQL security
13162918 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016 SQL Engine
13161356 4521701 FIX: Cardinality property for a table doesn't account for the rows in the delta store or the deleted bitmap if the table has a clustered columnstore index SQL Engine
13163758 4521739 FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016 SQL Engine
13134289 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016 SQL Engine
13141042 4522126 FIX: You may receive wrong results when you query sys.database_scoped_configurations in SQL Server 2016 SQL Engine
13107679 4522127 FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi-column statistics SQL performance
13147775 4522134 FIX: Subscriptions fail after you upgrade from SSRS 2012 to SSRS 2016 because of invalid character in mail header Reporting Services
13174187 4523102 FIX: SQL Server 2016 database remains in frozen I/O state indefinitely when backed up by VSS SQL Engine
Note The following table lists the status of individual Microsoft Knowledge Base articles. A separate Microsoft Knowledge Base article might not be created for each bug.
VSTS bug number KB article number Description Fix area Status
13113745 4513096 FIX: Repair fails for Machine Learning components on server with no Internet access Setup & Install Public
13077821 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server 2016 High Availability Public
13105506 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server 2016 SQL Engine Public
13122059 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016 SQL Engine Public
13130364 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server 2016 SQL performance Public
13098936 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server SQL Engine Public
13076524 4519679 FIX: Different users get the same model list with different permissions in SQL Server 2016 Data Quality Services (DQS) Public
13138952 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016 SQL Engine Public
13140478 4519847 FIX: MDS Configuration Manager reports SP2 base version in SQL Server 2016 Setup & Install Public
13069180 4520109 FIX: Access violation occurs when you restore In-Memory OLTP database in SQL Server 2016 In-Memory OLTP Public
13086240 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol SQL Engine Public
13122073 4520266 FIX: When you change SEEDING_MODE to MANUAL using ALTER AVAILABILITY GROUP, SQL Server 2016 does not cancel the current seeding operations to the secondary replica High Availability Public
13056235 4520739 FIX: Access violation error occurs when you try to insert results of stored procedure into a table with dynamic data masking in SQL Server 2016 SQL security Public
13162918 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016 SQL Engine Public
13161356 4521701 FIX: Cardinality property for a table doesn't account for the rows in the delta store or the deleted bitmap if the table has a clustered columnstore index SQL Engine Public
13163758 4521739 FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016 SQL Engine Public
13134289 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016 SQL Engine Public
13141042 4522126 FIX: You may receive wrong results when you query sys.database_scoped_configurations in SQL Server 2016 SQL Engine Public
13107679 4522127 FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi-column statistics SQL performance Public
13147775 4522134 FIX: Subscriptions fail after you upgrade from SSRS 2012 to SSRS 2016 due to invalid character in mail header Reporting Services Public
13174187 4523102 FIX: SQL Server 2016 database remains in frozen I/O state indefinitely when backed up by VSS SQL Engine Public

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 update:
 

Cumulative update package information


Prerequisites

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

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.