Physical and Logical Processor from DMV

This will help in having quick result on Physical and Logical Processor on a Server using SQL Server DMV.

DMV sys.dm_os_sys_info will provide this information

SELECT (cpu_count/hyperthread_ratio) as PhysicalCPUs,cpu_count as LogicalCPUs FROM sys.dm_os_sys_info

 

 

Leave a Reply

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