Cumulative Update 8 for SQL Server 2016 SP1

Applies to: Microsoft SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise More

This article describes Cumulative Update package 8 (CU8) (build number: 13.0.4474.0) for Microsoft SQL Server 2016 Service Pack 1 (SP1). This update contains fixes that were released after the initial 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 and all previous CU's can be located and downloaded from the Microsoft Update Catalog. However, Microsoft recommends that you always 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
11190572 4074696 FIX: Drillthrough operation fails and returns an error for row-level non-administrators in SSAS 2016 (Tabular model) Analysis Services
11403782 4058565 FIX: Assertion error when executing a stored procedure that references a large object in SQL Server 2014, 2016, and 2017 SQL performance
11455726 4074862 FIX: Unexpected error when you create a subcube in SQL Server 2016 Analysis Services (Multidimensional model) Analysis Services
11444126 4074881 FIX: Assertion error when data is bulk-inserted into a table that contains nonclustered and clustered columnstore indexes in SQL Server 2016 SQL Engine
11441098 4017445 FIX: A REDO thread is not available in the secondary replica after an availability database is dropped in SQL Server High Availability
10988062 4038932 FIX: Change Data Capture functionality does not work in SQL Server Integration Services
11405602 4046745 FIX: UPDATE statement fails silently when you reference a nonexistent partition function in the WHERE clause in SQL Server 2014, 2016, or 2017 SQL Engine
11405606 4048967 FIX: Can't enable or disable change data capture for a database after you attach it in SQL Server 2014, 2016, or 2017 SQL Engine
11405621 4054398 FIX: "Invalid comparison due to NO COLLATION" retail assert occurs in SQL Server 2014, 2016, and 2017 SQL Engine
11297169 4013247 FIX: SSRS subscriptions fail to run for a report that connects to a SharePoint External list Reporting Services
11396933 2932559 FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS Analysis Services
11511975 4077105 FIX: Out of memory error when the virtual address space of the SQL Server process is very low in SQL Server SQL Engine
11455724 4082865 FIX: SSAS crashes when a query is executed on a large partitioned table in SQL Server 2016 Analysis Services
11456360 4083949 FIX: SSAS may crash when you execute a DAX query by using a non-admin Windows user in SQL Server 2016 Analysis Services
11511973 4057307 FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 Analysis Services
11509590 4086136 FIX: SSAS stops responding when you execute an MDX query in SQL Server 2016 Analysis Services (Multidimensional model) Analysis Services
11426456 4087358 FIX: Expression-based connection string is cleared out when you configure data sources for the report in SSRS 2016 Reporting Services
11508542 4088901 FIX: Assertion failure when sys.dm_db_log_space_usage statement is run on a database snapshot in SQL Server 2016 High Availability
11183472 4089324 FIX: Error 15665 when you call sp_set_session_context repeatedly with null key value in SQL Server 2016 SQL Engine
11565899 4089099 FIX: It takes a long time to restore a TDE encrypted database backup in SQL Server SQL Engine
11529110 4089623 FIX: Out of memory occurs and query fails when you run MDX query with NON EMPTY option in SSAS 2016 and SSAS 2014 Analysis Services
11053682 4089950 Update to support partition elimination in query plans that have spatial indexes in SQL Server 2016 SQL performance
11323371 4090025 FIX: Random masking does not mask BIGINT values correctly in SQL Server SQL security
11456072 4090032 FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2016 multidimensional mode Analysis Services
11569422 4089948 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2016 SQL Engine
11281514 4052131 FIX: DMV sys.dm_os_windows_info returns wrong values for Windows 10 and Windows Server 2016 SQL Engine
11301441 4058700 FIX: Intermittent 9004 error when a backup is restored via Standby Mode in SQL Server 2014 SQL Engine
11336087 4057615 FIX: "Incorrect syntax near the keyword 'KEY'" error when you add an Oracle table with primary column named 'KEY' in SQL Server 2016 Integration Services
11339410 4058289 FIX: ALTER PROCEDURE WITH ENCRYPTION statement fails when you encrypt a non-published stored procedure in SQL Server 2016 SQL Engine
11420793 4058747 FIX: Error when upgrading SSIS catalog database in SQL Server 2016 Standard Edition Integration Services
11457917 4077683 FIX: System stored procedure sp_execute_external_script and DMV sys.dm_exec_cached_plans cause memory leaks in SQL Server 2016 and 2017 SQL Engine
11447600 4038881 FIX: Unexpected exception occurs when you process dimensions by using Process Update in SSAS 2016 Analysis Services
11309597 4073393 FIX: "The data area passed to a system call is too small" error when you start a Desktop Bridge application on a SQL Server 2014, 2016, and 2017 SQL Engine
11446129 3192154 A non-optimal query plan choice causes poor performance when values outside the range represented in statistics are searched in SQL Server 2016 and 2017 SQL performance
11548517 3147012 FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads In-Memory OLTP
11559191 4058174 FIX: Heavy tempdb contention occurs in SQL Server 2016 SQL Engine
11516257 4087406 FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014 and 2016 SQL Engine
11444654 4090486 FIX: Managed Backup does not handle renaming database name to a new name with trailing spaces in SQL Server 2016 Management Tools
11704293 4078596 FIX: Random access violations occur when you run monitoring stored procedure in SQL Server 2016 SQL Engine
11545426 4089276 Improves the query performance when an optimized bitmap filter is applied to a query plan in SQL Server 2016 and 2017 SQL Engine
11532381 4089819 FIX: "A time-out occurred while waiting for buffer latch -- type 4" error when you use Availability Groups in SQL Server 2016 or 2017 High Availability

Additonal resolutions

Resolutions to the following issues are also included in SQL Server 2016 SP1 CU8.

VSTS bug number Description
11701162 An assertion failure occurs when you stop automatic seeding for an availability group.
11704344 DAX queries runs slower than before after you back up a SSAS tabular database.
11704240 PolyBase crashes if PolyBase counters are missing or corrupted in Windows Performance Monitor.
11704339 Improves the query performance when an optimized bitmap filter is applied to the query plan.
11704329 Parallel recovery fails with a buffer latch time-out on a secondary replica of an Always On availability group.
11701219 The trend line of KPI is not refreshed when the dataset is updated.
11704269 Adds the support of using a SQL Server 2017 database as a data source of a tabular DirectQuery model in SSAS 2016.
11704293 Random access violations occur when you run [dbo].[usp_CollectWhoIsActiveData] in SQL Server 2016.
11704335 Data replication from Oracle to SQL fails when you update CU7 for SQL Server 2016 SP1.

Notes for this update


Hybrid environments deployment

When you deploy an update 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 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.