Orlando Colamatteo (1/14/2013)

---

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;