Consider the following scenario:
You use an instance of Microsoft SQL Server 2012 or SQL Server 2014 that has NUMA enabled.
SQL Server is configured to use many CPU cores across multiple NUMA nodes (for example, 4 NUMA nodes that have 12 cores each).
You run a compile-heavy workload that generates a high compilation rate from multiple concurrent connections.
In this scenario, you do not notice any increase in the results of a compilation/sec query with growing number of available cores beyond 12 or so. Also, CPU may show 100 percent utilization.
Note The severity of the CPU saturation depends on the number of cores per NUMA node and also on your compilation rate.
The issue occurs because SQL Server uses a data structure that may contribute to CPU contention patterns on NUMA-enabled hardware across concurrent compilations.
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:
To work around the issue, reduce the compilation rate in your SQL Server system.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.