MSSQL script to find actual number of physical CPU installed on the Server

Descriptions:
The Sql Server always see Logical cpu and it does not distinguish between Hyperthreaded logical cpu and physical processor using the below query we can find out actual number of physical cpu installed on the server

The first column represent logical processor and second column represent actual  physical processor installed on the server.

Script:


SELECT cpu_count AS Logical_CPU_Count , cpu_count / hyperthread_ratio AS Physical_CPU_Count FROM sys.dm_os_sys_info;

Example:

MSSQL script to find actual number of physical CPU installed on the Server

 

 


<<Click here to see all posts>>

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.