Cumulative Update 6 for SQL Server 2016 SP1

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.4457.0) for Microsoft SQL Server 2016 Service Pack 1 (SP1). This update contains fixes that were released after the release of SQL Server 2016 SP1.

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 SP1 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.

Additional hotfixes that are included in this cumulative update package


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
10918636 4049027 FIX: "AdomdConnectionException" error when SSRS 2016 data source uses msmdpump.dll Reporting Services
10868757 4040512 FIX: Error when exporting a Reporting Services report to PDF in SQL Server 2017 Reporting Services
10868767 4039510 FIX: Access violation occurs when you use sp_xml_preparedocument to open XML documents in SQL Server 2014 or 2017 XML
10067707 4019840 FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2016 and 2017 SQL Engine
10362525 4035062 FIX: Memory use with many databases greater in SQL Server 2016 than earlier versions SQL Engine
11078704 4039592 FIX: Cannot change the password for a SQL Server 2014 or 2016 service account when additional LSA protection is enabled Management Tools
11078711 4042232 FIX: Access violation when you cancel a pending query if the missing indexes feature is enabled in SQL Server 2014 and 2016 SQL performance
11078718 4043947 FIX: Bookmarks functionality does not work completely when you open a report in MHTML format through Outlook in SSRS 2014 and 2016 Reporting Services
10868722 4038882 FIX: SQL Server Managed Backup does not delete old backups that are beyond the retention period in SQL Server SQL Engine
10868738 4039509 FIX: SSAS crashes when you process an SSAS database or cube in SQL Server Analysis Services
10868725 4039511 FIX: Managed Backup fails intermittently because of SQLVDI error in SQL Server SQL Engine
10868770 4039735 FIX: "Non-yielding Scheduler" condition occurs for query with many expressions in SQL Server 2014 and 2016 SQL performance
10868732 4040376 FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server SQL Engine
11052450 4046056 FIX: Assertion occurs on accessing memory-optimized table through MARS SQL Engine
10864945 3010148 FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Analysis Services
10965956 4034789 FIX: An unexpected exception error occurs when a XIRR measure processes too many records in SSAS 2016 or 2017 Analysis Services
10870250 4040934 FIX: SQL Server Integration Service packages randomly hang if custom logging is enabled Integration Services
11029968 4051356 FIX: In-Memory database restore fails with errors in SQL server 2016 In-Memory OLTP
10980994 4052132 FIX: A non yielding scheduler issue occurs when you use the SQL Server Query Store feature in SQL Server SQL Engine
11124144 4052127 Hotfix: Alert Engine reads entire Application Event Log and sends aler Management Tools
10855950 4052125 FIX: Audit Log for ROLLBACK TRANSACTION event is not available in SQL Server 2016 SQL security
11060168 4052123 FIX: Sliding expiration for authentication cookie isn't working and fails to redirect to logon page in SSRS 2016 Reporting Services
11031058 4052121 FIX: Access violation for DMV queries run against a distributed availability group in SQL Server High Availability
10971673 4052119 FIX: Distributed Transactions in an AG database fails after restarting in SQL Server 2016 SQL Engine
10881290 4052131 FIX: DMV sys.dm_os_windows_info returns wrong values for Windows 10 and Windows server 2016 SQL Engine
10864854 4052572 FIX: SSAS 2016 crashes intermittently when you rename multi-dimensional database using script Analysis Services
11127649 4052625 FIX: Data retrieval queries using non-clustered index seek take much longer in SQL Server SQL Engine
10820931 4048942 FIX: "Stalled IOCP Listener" and "non-yielding IOCP listener" memory dumps generated SQL Server 2016 restart SQL Engine
10921921 4048943 FIX: Access violation on primary replica of AlwaysOn AG in SQL Server 2016 High Availability
11018232 4046858 FIX: Query that uses parallel query execution plan with "merge join" operation slow in Cumulative Update 3, 4 or 5 for SQL Server 2016 Service Pack 1 SQL performance
10935673 4052633 FIX: SELECT query that uses batch mode hash aggregate operator that counts multiple nullable columns returns incorrect results in SQL Server SQL performance
10330560 4053550 FIX: Processing XML message using Service Broker results in hung session in SQL Server 2016 SQL Engine
10678621 4037454 FIX: Policy-Based Management policy isn't working after you install CU2 for SQL Server 2016 SP1 Management Tools
10972567 4043624 FIX: Change tracking manual cleanup fails with table non-existence error in SQL Server SQL Engine
10868776 3208545 FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation Analysis Services
10868735 4022483 FIX: Error when you export a DQS knowledge base that contains domains in the DQS client in SQL Server Data Quality Services (DQS)
10868748 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server SQL Engine
10930335 4044064 FIX: "Request timed out" error when you change security options for an MDS security group in SQL Server 2016 Data Quality Services (DQS)
10934352 4045795 FIX: Thread pool exhaustion and CMEMTHREAD contention in AAG with data seeding in SQL Server 2016 SQL Engine
11047614 4052134 FIX: Errors 33111 and 3013 when you back up a TDE encrypted database in SQL Server SQL Engine
  4055758 FIX: Inconsistent behavior for returning trailing blanks at the end of CHAR and BINARY data in SQL Server SQL Engine

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 SP1.

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.