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

Symptoms


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.

Resolution


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:

References


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