• I like to check to see how many CPUs are online as well:

    -- cpu overview

    SELECT osi.cpu_count AS LogicalCpuCount,

    osi.hyperthread_ratio AS HyperthreadCoreRatio,

    osi.cpu_count / osi.hyperthread_ratio AS PhysicalCpuCount,

    (

    SELECT COUNT(*)

    FROM sys.dm_os_schedulers

    WHERE scheduler_id < osi.cpu_count

    AND is_online = 1

    ) AS LogicalCpuOnline

    FROM sys.dm_os_sys_info osi;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato