Cumulative Update 5 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 5 (CU5) (build number: 13.0.5264.1) 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
12491219 4055674 FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 and 2017 Integration Services Analysis Services
12488511 4090032 FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode Analysis Services
12496768 4099335 False error reporting when you execute the Test-SqlAvailabilityGroup cmdlet in SQL Server Management Tools
12571593 4316948 FIX: Access violation when you compile a query and histogram amendment is enabled with default Cardinality Estimation in SQL Server 2016 and 2017 SQL performance
12488519 4346803 FIX: Error occurs when you run sp_send_dbmail stored procedure that contains comma in sender email address and name in SQL Server Management Tools
12478822 4457953 FIX: Access violations and unhandled exceptions when you set automatic seeding for secondary replica or Distributed Availability Group replica in SQL Server High Availability
12488531 4459535 FIX: Masked data is exposed when a query that uses sp_cursorfetch is run in SQL Server if Dynamic Data Masking is enabled SQL Security
12482228 4460112 FIX: Access violation when you run a query that uses the XML data type in SQL Server 2014, 2016 and 2017 XML
12532591 4461562 FIX: Transactions and log truncation may be blocked when you use Query Store in SQL Server 2016 and 2017 SQL Engine
12488528 4463125 FIX: Error occurs when the Database Encryption Key is longer than 3,456 bits in SQL Server 2016 and 2017 SQL security
12488523 4463328 FIX: “An unexpected exception occurred” when you run an MDX query after an XMLA query to process a dimension in SSAS Analysis Services
12559856 4465247 FIX: Deadlock occurs in SSAS 2016 and 2017 when you run a DAX query with time intelligence calculation in parallel Analysis Services
12430802 4467006 FIX: The schedule changes to "Report-specific schedule" when you enable "Create cache snapshots on a schedule" for the report in SSRS 2016 Reporting Services
12531194 4469268 FIX: I/O error on a BPE file causes buffer time-out in SQL Server SQL Engine
12437948 4470528 FIX: Nested tablix shows small font or partial text in SSRS 2016 and later versions Reporting Sevices
12574520 4470916 FIX: Out of memory error occurs when Database Node Memory (KB) drops below 2 percent in SQL Server 2014 and 2016 SQL Engine
12578033 4475322 FIX: "Non-yielding" error occurs when there is a heavy use of prepared statements in SQL Server 2014 and 2016 SQL Engine
12486147 4479280 FIX: Restore of TDE-compressed backup is unsuccessful when backing up database to a 512-byte Emulation disk in SQL Server SQL Engine
12517650 4479283 FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster SQL Engine
12480339 4480635 FIX: High CPU usage when there are many batch requests in SQL Server 2016 SQL performance
12492081 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition SQL Engine
12519485 4480640 FIX: Server crashes when you cancel DBCC CHECKDB against a large database in SQL Server 2016 SQL Engine
12456075 4480641 FIX: Columnstore Index build request may time out after 25 seconds though the memory grant time-out is configured in SQL Server 2016 SQL performance
12536281 4480643 Improvement: Performance issue when you create or modify entities, attributes, users, or groups when page load permissions are used in SQL Server Data Quality Services (DQS)
12522073 4480647 Update adds improvements and fixes issues when you use an Oracle RAC environment in SQL Server Integration services
12517286 4480648 FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object SQL Engine
12517207 4480650 FIX: sys.fn_hadr_backup_is_preferred_replica returns TRUE for more than one secondary replica even if the priority values are identical in SQL Server 2016 High Availability
12373383 4480653 FIX: Error occurs when you run a query that includes a Boolean field against PolyBase external tables in SQL Server 2016 and 2017 SQL Engine
12490152 4480654 FIX: Large white space appears between the textbox and tablix when a report is viewed by using SSRS 2016 Report Manager Reporting services
12575103 4480709 FIX: Error 18204 during automatic backup in virtual machines when the backup file is split into multiple files Management Tools
12501413 4480795 FIX: An unexpected error occurs when you run an MDX query against an Excel pivot table in SSAS 2016 Analysis services
12487675 4481148 FIX: Restore or Restore Verifyonly of a TDE-compressed backup fails with error 33111 and 3013 in SQL Server 2016 and 2017 SQL Engine
12576803 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server 2016 SQL Engine
12450169 4483571 FIX: Possible assertion failure when a cross-database transaction involving an Availability Group database is committed from a SQL Server trigger SQL Engine
12552077 4483593 Snapshot Isolation and Savepoint support added for Availability Group databases on the same instance with DTC enabled in SQL Server SQL Engine
12507746 4486852 FIX: Access violation when you run a query that contains a batch-mode hash join on Clustered Columnstore Index table in SQL Server 2016 SQL Engine
12594029 4486931 FIX: Upgrade to SQL Server 2016 SP2 CU3 or CU4 fails with an error when sysadmin account "sa" is renamed in SQL Server 2016 SQL Engine
12599226 4486935 FIX: Query results are not as expected when you run a particular query from Excel in SQL 2014 SP2 CU14 or later version (2016, 2017 or 2019) Analysis Services
12519048 4486936 FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server 2016 Management Tools
12571722 4486937 FIX: Publishing MDS data from Excel fails when you save the changes to workbook, close and reopen it in SQL Server 2016 Data Quality Services (DQS)
12577822 4486939 FIX: Access violation occurs when SQL is trying to promote a transaction to DTC while collecting QDS statistics SQL Engine
12588285 4486940 FIX: Assertion failure occurs when you try to back up database in limited disk space in SQL Server 2016 SQL Engine
12478832 4486941 Improvement: A way to configure logging for Hadoop bridge in PolyBase in SQL Server 2016 SQL Engine
12476763 4487094 FIX: Query Store enabled database takes long time on startup after you apply cumulative update for a SQL Server version 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 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.