FIX: Queries that use CHANGETABLE use much more CPU in SQL Server 2014 SP1 or in SQL Server 2016

Прилага се за: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise


Assume that you have installed the Cumulative Update 6 for Microsoft SQL Server 2014 Service Pack 1 (SP1) or you are using Microsoft SQL Server 2016. When you run a query that contains a CHANGETABLE function, it may use much more CPU than before.


Service pack information

This issue was fixed in the SQL Server 2016 Service Pack 1 (SP1) . See the SQL Server 2016 build versions .

Cumulative update information

The issue was fixed in the following cumulative update of SQL Server:


Learn about the terminology that Microsoft uses to describe software updates.