Search This Blog

Physical and logical CPU counts from SQL Server

The following simple query will help return these information
SELECT (cpu_count/hyperthread_ratio) as PhysicalCPUs,cpu_count as LogicalCPUs
FROM sys.dm_os_sys_info

No comments: