Script of the Day - Find the Cores on a System

Script of the Day - Find the Cores on a System

  • Comments 4

Sure, you can get the number of processors fairly easily ffrom SQL Server. But did you know you can also get the number of actual cores as well? This little gem works with SQL Server 2005:

SELECT  cpu_count/hyperthread_ratio AS sockets

FROM sys.dm_os_sys_info;
GO 

 

Leave a Comment
  • Please add 7 and 4 and type the answer here:
  • Post
Page 1 of 1 (4 items)