Cumulative Update 7 for SQL Server 2016 SP1

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

Cumulative Update 7 (CU7) for Microsoft SQL Server 2016 Service Pack 1 (SP1) was also released as a SQL Server Security Bulletin on January 4, 2018, KB 4058561. See KB 4058561 for more information. In other words, the same physical package (SQLServer2016-KB4057119-x64.exe) was made available both as CU7 (KB4057119) and the Security Bulletin (KB 4058561).

Because of this, you may already have CU7 installed as part of that security bulletin release and installation of this CU is unnecessary. If you do try to install CU7 after ADV180002, you may receive the following message:

There are no SQL Server instances or shared features that can be updated on this computer
This indicates that CU7 is already installed and no further action is required.
This article describes cumulative update package 7 (13.0.4466.4) 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 from the Microsoft Download Center.

Only the most recent CU that was released for SQL Server 2016 SP1 is available from the Download Center.
 
  • Each new CU contains all the fixes that were included in 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
11173911 4056117 FIX: Assertion occurs when you pass memory-optimized table variable into a stored procedure as table-valued parameter in SQL Server 2016 SQL Engine
11199159 4037412 FIX: Error 156 when SQL Server replication article contains either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID SQL Engine
11177245 4056831 FIX: Error 27231 occurs when SSIS package that contains localized language is deployed in SQL Server 2016 Integration Services
11289879 4056955 FIX: Queries that casts string or binary data to XML take a long time to compile in SQL Server 2016 SQL security
11293964 4057055 FIX: A deadlock occurs when you run a parallel query on a clustered columnstore index in SQL Server 2016 SQL Engine
11176971 4053293 Update to enable PolyBase technology in SQL Server 2016 and 2017 SQL Engine
11303628 4057190 FIX: Error 14684 when you reconfigure Management Data Warehouse in a named instance of SQL Server 2016 Management Tools
11272976 4057212 FIX: Memory leak occurs when you back up a database that contains memory-optimized objects in SQL Server 2016 In-Memory OLTP
11317877 4057280 FIX: High CPU usage when large index is used in a query on a memory-optimized table in SQL Server 2016 In-Memory OLTP
11204967 4055556 FIX: Error when you rebuild a single partition of an index online in SQL Server 2014 and 2016 SQL performance
11229828 4055735 FIX: DBCC CHECKDB returns consistency errors if SOUNDEX function is used in PERSISTED computed columns in SQL Server SQL Engine
11281512 4042948 FIX: Data-driven subscription fails after you upgrade from SSRS 2008 to SSRS 2016 Reporting Services
11204967 3213683 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2014 or 2016 SQL engine
10855390 4055727 FIX: Recovery of database takes a long time when it contains memory-optimized tables in SQL Server 2016 In-Memory OLTP
11017620 4058174 FIX: Heavy tempdb contention occurs in SQL Server 2016 SQL Engine
11057297 2963836 FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS Reporting Services
11091931 4055674 FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 Integration Services Analysis Services
11296783 4057307 FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 Analysis Services
11200450 4055456 FIX: "Incompletely installed" error on Feature Selection page when you modify the current installation of SQL Server 2016 SP1 or SQL Server 2016 SP1 CU5 Setup & Install
11205782 4055281 FIX: "Msg 3948" error when you run a query on secondary replica of secondary availability group in SQL Server 2016 High Availability
11217082 4056821 FIX: Log shipping fails when you use it together with Always On Availability Groups in SQL Server 2016 High Availability
11295738 4057759 FIX: Internal error when you drill down hierarchy members in SSAS 2016 in multidimensional mode Analysis Services

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.