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;


No comments.

Leave a Comment

Please register or log in to leave a comment.