KB3205413 - Cumulative update 3 for SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

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:

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 bugnumberKB articlenumberDescriptionFix area
82543783188157Functional area permissions are lost after you upgrade to SQL Server 2016 Master Data Services Master Data Services (MDS)
82544193188160FIX: Cannot add new explicit hierarchies after you delete all the existing explicit hierarchies from an entity in SQL Server 2016 Master Data Services MDS
82543903188158FIX: Filter and Change Tracking settings are removed after you change a domain-based attribute in SQL Server 2016 Master Data Services MDS
82543143188150Version copy fails when entity contains collections but not consolidated members in SQL Server 2016 MDS MDS
77099093172956FIX: SQL Server crashes when you commit a Hekaton transaction after a native procedure is dropped In-Memory OLTP
82543693188153FIX: It takes a very long time to purge lots of members from an entity in SQL Server 2016 Master Data Services MDS
85271503197589FIX: Heap scan may cause high PAGEIOLATCH_SH waits in SQL Server 2016 SQL service
86351983198766FIX: 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
86351823198760FIX: Error 19432 and time-out errors when you use SQL Server 2016 AlwaysOn Availability Groups High Availability
82969023189855FIX: Intermittent non-yielding conditions, performance problems and intermittent connectivity failures in SQL Server 2016 SQL performance
82597973198775FIX: SQL Server 2016 Query Optimizer incorrectly adds a SORT operator if a partitioned table only contains a single partition SQL performance
81980353180263FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 or 2016 Analysis Services Analysis Services
85323193197758FIX: Time-out error when you process multiple partitions in parallel in SQL Server 2016 Analysis Services (Tabular model) Analysis Services
81980063171681Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
81980383181260SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server Analysis Services
84638433197893FIX: Rolling upgrade for an AlwaysOn replica or a database mirroring instance fails after Cumulative Update 1 for SQL Server 2016 is installed High Availability
85757613180087Poor performance when you run INSERT.. SELECT operations in SQL Server 2016 SQL service
83469673180060FIX: Queries that use CHANGETABLE use much more CPU in SQL Server 2014 SP1 or in SQL Server 2016 SQL service
86678633198846FIX: 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
85189283197403FIX: 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
84905363196100FIX: Exception occurs during parallel processing of partitions if a column is re-encoded in SQL Server 2016 Analysis Services
84637283200975FIX: An assertion occurs when you use parallel redo in a secondary replica of a SQL Server AlwaysOn Availability Group High Availability
84920663196102FIX: Performance issues caused by continuous growth of memory in SQL Server 2016 Analysis Services Analysis Services
84948823195901FIX: SQL Server 2016 crashes when a Tuple Mover task is ended unexpectedly SQL service
82083013190222FIX: The user interface of SSRS 2016 mobile report contains multiple minimal display issues Reporting Services
84421153194923FIX: Error 976 occurs when you run the DBCC CHECKDB command on an unreadable secondary replica of SQL Server 2016 Availability Group SQL service
85285543197605FIX: SQL Server 2016 hangs when you restore databases that contain memory-optimized tables In-Memory OLTP
84626633197817FIX: Error when you process a calculated column in a table with multiple partitions Analysis Services
82544103188154Cannot filter attributes when you use the SQL Server 2016 Master Data Services Add-in on a non-English version of Excel MDS
78551663168708FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server Management Tools
8464882 3197952FIX: 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:

Cumulative update package information


To apply this cumulative update package, you must be running SQL Server 2016.

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.