- 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.
Note The severity of the CPU saturation depends on the number of cores per NUMA node and also on your compilation rate.
The issue was first fixed in the following cumulative update of SQL Server.
Article ID: 2928300 - Last Review: 24 Jul 2014 - Revision: 1