Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!