SQL Server not using all CPU cores/threads
16
votes
3
answers
59103
views
After upgrading our SQL Server's hardware, we noticed in the Windows Task Manager that the SQL instance is only using half of the threads available to it:
.
The server has the following hardware and software:
- Windows 2008 R2 Enterprise 64bit SP1
- Intel Xeon E7-4870 - 4 processors (40 cores, 80 threads)
- Microsoft SQL Server **2012 Enterprise Edition (64-bit)**
Running

select cpu_count from sys.dm_os_sys_info
returns 40.
The OS sees all 80 threads.
Why is only half the server's processing power being used?
We have the same hardware and software on two servers and they both exhibit the same behavior.
Asked by Moharrer
Sep 15, 2013, 10:03 AM
Last activity: Aug 26, 2022, 08:03 AM
Last activity: Aug 26, 2022, 08:03 AM