FIX: SQLCLR function takes a longer time to run the query in CU 14 than RTM of SQL Server 2017

Applies to: SQL Server 2017 Developer WindowsSQL Server 2017 Enterprise WindowsSQL Server 2017 Enterprise Core Windows

Symptoms


When you run a query in both SQL Server 2017 RTM and Cumulative Update 14 (CU 14) of SQL Server 2017, you notice that the SQL Common Language Runtime (SQLCLR) function takes a longer time to run the query in CU 14 than in RTM version of SQL Server 2017.

Cause


The UpdateCpuUsage() function isexpensive and it is used to collect CPU utilization when CLR function is executed. After you apply this fix, we onlycollect it when profiling is ON.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This issue is fixed in the following cumulative update for SQL Server:

About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

References


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