KB3205413 - Cumulative update 3 for SQL Server 2016

Cumulative Update 3 (CU3) for SQL Server 2016 was also released as a SQL Server Security Bulletin on 11/8/2016, KB3194717. Please see MS16-136 for details. As a result of this, you may already have CU3 installed as part of that security bulletin release and installation of this CU is unnecessary. If you do attempt to install CU3 after MS16-136, you may receive the following message:

There are no SQL Server instances or shared features that can be updated on this computer

Note This message indicates that CU3 is already installed and no further action is required.

Note The package name for CU3 (SQLServer2016-KB3194717-x64.exe) contains the security update MS16-136 KB number (3194717), not the CU3 KB number (3205413). This can be ignored as a single package services both release channels.

This article describes cumulative update package 3 (build number: 13.0.2186.6) for Microsoft SQL Server 2016. This update contains fixes that were released after the release of SQL Server 2016.

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 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:

Download the latest cumulative update package for Microsoft SQL Server 2016 now.

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 bugnumber	KB articlenumber	Description	Fix area
8254378	3188157	Functional area permissions are lost after you upgrade to SQL Server 2016 Master Data Services	Master Data Services (MDS)
8254419	3188160	FIX: Cannot add new explicit hierarchies after you delete all the existing explicit hierarchies from an entity in SQL Server 2016 Master Data Services	MDS
8254390	3188158	FIX: Filter and Change Tracking settings are removed after you change a domain-based attribute in SQL Server 2016 Master Data Services	MDS
8254314	3188150	Version copy fails when entity contains collections but not consolidated members in SQL Server 2016 MDS	MDS
7709909	3172956	FIX: SQL Server crashes when you commit a Hekaton transaction after a native procedure is dropped	In-Memory OLTP
8254369	3188153	FIX: It takes a very long time to purge lots of members from an entity in SQL Server 2016 Master Data Services	MDS
8527150	3197589	FIX: Heap scan may cause high PAGEIOLATCH_SH waits in SQL Server 2016	SQL service
8635198	3198766	FIX: Error 19432 is logged after you upgrade Availability replicas in an Always On Availability Group to Cumulative Update 1 for SQL Server 2016	High Availability
8635182	3198760	FIX: Error 19432 and time-out errors when you use SQL Server 2016 AlwaysOn Availability Groups	High Availability
8296902	3189855	FIX: Intermittent non-yielding conditions, performance problems and intermittent connectivity failures in SQL Server 2016	SQL performance
8259797	3198775	FIX: SQL Server 2016 Query Optimizer incorrectly adds a SORT operator if a partitioned table only contains a single partition	SQL performance
8198035	3180263	FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 or 2016 Analysis Services	Analysis Services
8532319	3197758	FIX: Time-out error when you process multiple partitions in parallel in SQL Server 2016 Analysis Services (Tabular model)	Analysis Services
8198006	3171681	Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6	Reporting Services
8198038	3181260	SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server	Analysis Services
8463843	3197893	FIX: Rolling upgrade for an AlwaysOn replica or a database mirroring instance fails after Cumulative Update 1 for SQL Server 2016 is installed	High Availability
8575761	3180087	Poor performance when you run INSERT.. SELECT operations in SQL Server 2016	SQL service
8346967	3180060	FIX: Queries that use CHANGETABLE use much more CPU in SQL Server 2014 SP1 or in SQL Server 2016	SQL service
8667863	3198846	FIX: Poor performance occurs during a table scan when a query is used that filters non-Primary Key columns on in-memory history tables	SQL performance
8518928	3197403	FIX: SQL Server 2016 Reporting Services keeps cycling on trying to unload application domains when Report Server is configured on a Network Load Balancing Cluster	Reporting Services
8490536	3196100	FIX: Exception occurs during parallel processing of partitions if a column is re-encoded in SQL Server 2016	Analysis Services
8463728	3200975	FIX: An assertion occurs when you use parallel redo in a secondary replica of a SQL Server AlwaysOn Availability Group	High Availability
8492066	3196102	FIX: Performance issues caused by continuous growth of memory in SQL Server 2016 Analysis Services	Analysis Services
8494882	3195901	FIX: SQL Server 2016 crashes when a Tuple Mover task is ended unexpectedly	SQL service
8208301	3190222	FIX: The user interface of SSRS 2016 mobile report contains multiple minimal display issues	Reporting Services
8442115	3194923	FIX: Error 976 occurs when you run the DBCC CHECKDB command on an unreadable secondary replica of SQL Server 2016 Availability Group	SQL service
8528554	3197605	FIX: SQL Server 2016 hangs when you restore databases that contain memory-optimized tables	In-Memory OLTP
8462663	3197817	FIX: Error when you process a calculated column in a table with multiple partitions	Analysis Services
8254410	3188154	Cannot filter attributes when you use the SQL Server 2016 Master Data Services Add-in on a non-English version of Excel	MDS
7855166	3168708	FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server	Management Tools
8464882	3197952	FIX: Performance regression in the expression service during numeric arithmetic operations in SQL Server 2016	SQL performance

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: