Cumulative Update 5 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 5 (build number: 13.0.4451.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


VSTS bug number KB article number Description Fix area
10660258 4038113 FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server 2016 SQL performance
10682252 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 SQL Engine
10665155 4033789 FIX: A memory leak may occur when you perform Process Update operations in SSAS 2014 or 2016 Analysis Services
10755057 4039776 FIX: Incorrect behavior when you use memory-optimized tables with "where exists" statement in SQL Server 2016 In-Memory OLTP
10365499 4040085 FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 Analysis Services
10682297 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server 2014 or 2016 is also installed Data Quality Services (DQS)
10357715 4040519 FIX: Automatic seeding in Availability Groups randomly causes error 41169 in SQL Server 2016 High Availability
10661031 4040530 FIX: Log chain break in the "managed_backup.fn_available_backups" table in SQL Server 2016 Management Tools
10865719 4024393 FIX: Assertion error occurs on the secondary replica when you resume a suspended availability database in SQL Server 2016 SQL Engine
10713456 4038590 FIX: SSIS package that contains German umlauts characters fails on execution after Incremental Package Deployment in SQL Server 2016 Integration Services
10682303 4023926 FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server 2014 or 2016 SQL Engine
10531816 4039125 FIX: "The folder ... does not exist" error when deleting a folder in web portal of SQL Server 2016 Reporting Service Reporting Services
10657005 4039058 FIX: Report Viewer Web Part does not allow a full vertical scrollbar after you set a specific web part height Reporting Services
10331946 4042251 FIX: Database mirroring failover fails with error 3456 in SQL Server 2016 High Availability
10682272 4022753 FIX: SSAS 2014 or 2016 crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Analysis Services
10270914 4040108 FIX: Backup of availability database via VSS-based application may fail in SQL Server 2016 SQL Engine
10682268 4023679 FIX: Timeout when you back up a large database to URL in SQL Server 2014 or 2016 SQL Engine
10571964 4040531 FIX: Constraint violation error returned by the managed_backup.fn_available_backups function after you install the Cumulative Update 2 for SQL Server 2016 SP1 SQL Engine
10823774 4040539 FIX: Error message when you use the sp_execute_external_script stored procedure to insert data and specify @parallel value to 1 in SQL Server 2016 SQL Engine
10682260 4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Management Tools
10407522 4037435 FIX: Access violation occurs when you query the sys.availability_groups catalog view in SQL Server 2016 High Availability
10646166 4037412 FIX: Error when you configure an Azure SQL database to subscribe a transactional publication that contains spatial indexes in SQL Server 2016 SQL Engine
10333557 4039124 FIX: Memory spike in LSASS.EXE when you enable Basic Authentication mode in SSRS 2016 Reporting Services
10682257 3108537 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server SQL Engine
10682322 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server 2016 SQL Engine
10682301 4024311 FIX: "Non-yielding Scheduler" condition occurs on spinlock contention in Microsoft SQL Server 2014 or 2016 SQL Engine
10739035 4039736 FIX: SSIS package does not start when it's run by a CLR stored procedure whose user does not have SYSADMIN permissions SQL Engine
10686654 4039868 FIX: Performance drop when using In-Memory OLTP with Always On availability groups in SQL Server 2016 In-Memory OLTP
10716344 4039966 FIX: Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command in SQL Server 2016 SQL Engine
10764990 4040014 FIX: Query that joins a view and contains UNION ALL slow in SQL Server 2016 SQL performance
10729324 4022935 FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014 or 2016 High Availability
10679744 4040533 FIX: Returns incorrect results when computed column is queried after installing hotfix that's described in KB 3213683 and enabling TF 176 in SQL Server 2016 SQL Engine
10682284 4024563 FIX: Unhandled exception when you export a SSRS report to a .pdf file if the page height is set to 8.5 inches in SQL Server 2014 or 2016 Reporting Services
10407829 4039126 FIX: Horizontal scroll bar is missing from the Subscription page in SSRS 2016 web portal Reporting Services
10821558 4039089 FIX: EXCEPTION_ACCESS_VIOLATION error when you execute the sys.sp_MScdc_capture_job stored procedure in SQL Server 2016 SQL Engine
10729321 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Reporting Services
10817762 4040276 FIX: Indirect checkpoints on the tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 SQL Engine
10682310 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server 2016 MDS Data Quality Services (DQS)
10775059 4040510 FIX: A dump file is generated when you run a sp_execute_external_script statement in parallel mode in SQL Server 2016 SQL Engine
10765165 4040535 FIX: SQL Server Managed Backups do not run a scheduled log backup in SQL Server 2016 SQL Engine
9900110 4024860 Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 SQL performance
10762336 4042962 FIX: "An unknown error" for "Show More Members" on Entity Dependencies explorer page in SQL Server 2016 Master Data Services Data Quality Services (DQS)
10682313 4043103 FIX: Load data from staging tables takes a much longer time to finish when recursive hierarchy is used in SQL Server 2016 Master Data Services Data Quality Services (DQS)
10988055 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Integration Services
10988063 4038932 FIX: Change Data Capture functionality does not work in SQL Server Change Data Capture

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.