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 is expensive and it is used to collect CPU utilization when CLR function is executed. After you apply this fix, we only collect 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.
