SELECT COUNT(DISTINCT scheduler_id) AS TotalVisibleCores
FROM sys.dm_os_schedulers
WHERE scheduler_id < 1048576 — >= 1048576 = hidden
Author Archives: Ram - Page 78
How many cores are visible to SQL Server?
Posted by Ram
on April 7, 2015
No comments