Query to find affinity of my schedulers to CPUs Aneesh select scheduler_id, CAST (cpu_id as varbinary) AS scheduler_affinity_mask from sys.dm_os_schedulers