T-SQL to Find Physical and Logical Processors

T-SQL to Find Physical and Logical Processors

Rate This
  • Comments 1

I ran into a licensing question the other day on Physical versus Logical Processors. Happily, Microsoft only charges you for Physical sockets - which you can find with this query:

SELECT
  cpu_count / hyperthread_ratio AS PhysicalCPUs
FROM
  sys.dm_os_sys_info

And then this query will show you how many logical Processors SQL Server "sees" for the Instance:

SELECT
  cpu_count AS logicalCPUs
FROM
  sys.dm_os_sys_info
Leave a Comment
  • Please add 5 and 1 and type the answer here:
  • Post