KB4495256 - Cumulative Update 7 for SQL Server 2016 SP2

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 SP2 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 icon Download the latest cumulative update package for SQL Server 2016 SP2 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, we recommend that you always install the latest cumulative update that is available.

Additional hotfixes that are included in this cumulative update package

VSTS bug number	KB article number	Description	Fix area
12865856	4338636	FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014 and 2016	Integration Services
12809383	4488036	FIX: Repl_Schema_Access wait issues when there are multiple publisher databases on the same instance of SQL Server 2016	SQL Engine
12822163	4489150	FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014 and 2016	SQL performance
12673144	4490136	FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016	SQL performance
12722070	4491560	FIX: Access violation occurs when you query sys.dm_hadr_availability_replica_states in SQL Server 2016	High Availability
12819451	4491696	FIX: Floating point exception error 3628 occurs when you query DMV sys.dm_db_xtp_hash_index_stats in SQL Server 2016	In-Memory OLTP
12639785	4492604	FIX: Manual failover between forwarder and secondary replica fails with all replicas synchronized in SQL Server 2016	High Availability
12931646	4493364	FIX: Error occurs when you back up a virtual machine with non-component based backup in SQL Server 2016	SQL Engine
12770729	4493765	FIX: HTML files cannot be opened directly from the web portal in SSRS 2016	Reporting Services
12783210	4494225	FIX: Access violation occurs when you run a query against sys.availability_replicas in SQL Server 2016	High Availability
12796269	4494805	FIX: Adding new Publication may fail if distribution database is in AG and collation is set to BIN in SQL Server 2016	SQL Engine
12801855	4495547	FIX: Remote ad hoc queries that use OPENDATASOURCE produce an incorrect error message when the new OLE DB provider is used	SQL Engine
12800325	4497222	FIX: Database may crash when multiple threads update permissions on the same database in SQL Server 2016	Analysis Services
12816588	4497225	FIX: Query against table with both clustered columnstore index and nonclustered rowstore index may return incorrect results in SQL Server 2016	SQL Engine
12865860	4497230	FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014 and 2016	High Availability
12865876	4497701	FIX: Columnstore filter pushdown may return wrong results when there is an overflow in filter expressions in SQL Server 2014 and 2016	SQL Engine
12748363	4497928	FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016	SQL Engine
12865873	4499231	FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014 and 2016	SQL Engine
12866582	4500403	FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2016	SQL Engine
12860702	4500770	FIX: AG is suspended when cross-database transaction is applied on AG databases in SQL Server 2016	High Availability
12750695	4501052	Improvement: Enable PDW APS to access TRY_CONVERT() function in SQL Server 2016	SQL Engine
12865966	4501205	Fix: "Non-yielding Scheduler" occurs when you clean up in-memory runtime statistics of Query Store in SQL Server 2016	SQL Engine
12834142	4501741	FIX: URL encoding is incorrect when the Excel workbook name is in Russian language in SSRS 2016	Reporting Services
12823777	4501797	FIX: Data movement to DAG Forwarder does not resume automatically after connection time-out in SQL Server 2016	High Availability
12805639	4502400	FIX: SQL Server 2016 does not perform the requested pre-row assignments when you use MERGE statement that performs assignments of local variables for each row	SQL performance
12816125	4502427	FIX: Access violation occurs when you run sys.fn_dump_dblog function in SQL Server 2016	SQL Engine
12572712	4502428	FIX: Assertion error occurs when you run a query to access sys.dm_db_xtp_checkpoint_files in SQL Server 2016	In-Memory OLTP

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

SQL Server failover cluster rolling update and service pack process.

Note If you don't want to use the rolling update process, follow these steps to apply an update:
1. Install the update on the passive node.
2. Install the update on the active node (requires a service restart).
Upgrade and update of availability group servers that use minimal downtime and data loss.

Note If you enabled AlwaysOn with SSISDB catalog, see the information about SSIS with AlwaysOn for more information about how to apply an update in these environments.
How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
How to apply a hotfix for SQL Server in a replication topology
How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
Overview of SQL Server Servicing Installation

Language support

SQL Server Cumulative Updates are currently multilingual. Therefore, this cumulative update package is not specific to one language. It applies to all supported languages.

Components (features) updated

One Cumulative Update package includes all available updates for ALL SQL Server 2016 components (features). However, the cumulative update package updates only those components that are currently installed on the SQL Server instance you select to be serviced. If a SQL Server feature (e.g. Analysis Services) is added to the instance after this CU is applied, you must re-apply this CU to update the new feature to this CU.

Support for this update

If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and to issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, go to the Microsoft support website.

How to uninstall this update

In Control Panel, select View installed updates under Programs and Features.
Locate the entry that corresponds to this cumulative update package under Microsoft SQL Server 2016.
Press and hold (or right-click) the entry, and then select Uninstall.

KB4495256 - Cumulative Update 7 for SQL Server 2016 SP2

Cumulative update

How to obtain this cumulative update package

Additional hotfixes that are included in this cumulative update package

Notes for this update

Hybrid environments deployment

Language support

Components (features) updated

Support for this update

How to uninstall this update

Cumulative update package information

Need more help?

Want more options?

Was this information helpful?

Thank you for your feedback!