Cumulative Update 1 for SQL Server 2016 SP1

Applies to: Microsoft SQL Server

This article describes cumulative update package 1 (build number: 13.0.4411.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 .
Note After you apply this update, Database Mail does not work on computers that do not have the .NET Framework 3.5 installed. Microsoft is currently working on addressing this in a future cumulative update. See the following KB article for more information about affected builds and suggested workarounds: 

FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed

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.

Hotfixes that are included in this cumulative update package


VSTS bug numberKB article numberDescriptionFix area
81980253025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS
Analysis Services
90084423210747FIX: The “sys.dm_db_column_store_row_group_physical_stats” query runs slowly on SQL Server 2016
SQL service
91000683211605FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode
Analysis Services
86682063212252FIX: Parameter values aren't contained in the URL when the parameter is used multiple times in a drillthrough custom URL
Reporting Services
89777493208460FIX: DMV sys.dm_os_spinlock_stats returns incorrect results after you install SQL Server 2016 RTM CU2
SQL service
90972483198827FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members
Analysis Services
89777523212789FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016
SQL service
90857863213524FIX: Text box is missing when the toggle action is enabled in SSRS 2016
Reporting Services
91486393213703FIX: An Always On secondary replica goes into a disconnecting state
High Availability
90999373208178FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services
Analysis Services
90716493211220FIX: KPIs bound to a dataset together with parameters are not updated during cache refresh
Reporting Services
90713023212523FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory
SQL service
91261133213288FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group
High Availability
90762763206401FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016
In-Memory OLTP
89777513201865FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server 2014 or 2016
SQL service
81980223175883Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server
SQL performance
90694863211646FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016
SQL service
90698583212214FIX: Cannot execute the DBCC CLONEDATABASE command on an instance of SQL Server 2016 SP1 after an in-place upgrade
SQL service
91001393212541FIX: SSAS may crash when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase
Analysis Services
81979843164404FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016
Integration Services
90490633210597FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016
SQL service
90762813209878FIX: SQL Server runs out of memory when you query data from memory-optimized tables if Resource Governor is enabled
In-Memory OLTP
90490623211990FIX: List view layout of the SSRS 2016 web portal reverts to Tiles view layout in Google Chrome when the page is refreshed
Reporting Services
90490603213496FIX: Cannot save a subscription when you browse to SSRS 2016 web portal by using Internet Explorer
Reporting Services
91002613198356FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services
Analysis Services
90972563198826FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server 2012 or 2014 Analysis Services
Analysis Services
89866173209520FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly
Analysis Services
89970693210699FIX: Error messages are logged if database mirroring is configured by Transact-SQL in SQL Server 2016 and no database activity occurs for more than 90 seconds
High Availability
90715203209896Update to enable changing the PolyBase service accounts without reinstalling the PolyBase feature in SQL Server 2016
SQL service
90762763206401FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016
In-Memory OLTP
89997083213263FIX: Error when create a stored procedure that uses a synonym together with an index hint in SQL Server 2016
SQL service
90925583211338FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016
SQL service
91367773213283FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016
SQL service
90127113188151FIX: Can't save a business rule when the condition and action refer to different parent entities in SQL Server 2016 Master Data Services
Master Data Services (MDS)
90566733210708FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates
SQL service
89817773211641FIX: Fail to view report with Edge or Chrome when you use a blank space parameter on SSRS 2016
Reporting Services
89997073212482FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016
SQL service
81979753161403The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server
Reporting Services
88089923209426FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state
Analysis Services
90126123210087FIX: Errors when you try to save MDS business rules in SQL Server 2016
MDS
88353663211948FIX: "Adjust height to fit zone" setting of the SSRS 2016 Report Viewer Web Part isn't respected on a SharePoint webpage
Reporting Services
90493603211991FIX: SQL Server 2016 Reporting Services mobile reports can't be rendered in your browser through Active Directory Application Proxy
Reporting Services
85008283197879FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent
Management Tools
90980363206912FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks
Analysis Services
89997063210395FIX: A dump file is generated when you enable system-versioning on a table in SQL Server 2016
SQL service
91283133213291FIX: Kernel crash when you create a database after you drop a database that contains FILESTEAM data in SQL Server 2016
SQL service
90788473213709FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services
Analysis Services
88123073205964FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016
SQL service
81980283178526An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 or 2016
SQL connectivity
89874083210652FIX: Automatic update of statistics feature doesn't run after you truncate a table that has a clustered columnstore index
SQL performance
90000173212723FIX: A query that contains a hint against a view that references at least one temporal table in a different database can generate a dump file in SQL Server 2016
SQL service
91330963213778FIX: MDS business rule does not trigger on an attribute value change if the attribute belongs to a change tracking group
MDS
90980403212916FIX: SSAS may crash on query execution if a predefined role is specified in the connection string
Analysis Services
90972543183686FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS
Analysis Services
 8103261 3190548 Update introduces CREATE OR ALTER Transact-SQL statement in SQL Server 2016 SQL service

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.