Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Determining the no of processor cores in your SQL Server

SELECT cpu_count/hyperthread_ratio AS cores
   FROM sys.dm_os_sys_info;

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.