We walk in the dark places no others will enter
We stand on the bridge and no one may pass

-- 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;