Monthly Archives: April 2015 - Page 24

How many cores are visible to SQL Server?

Posted by on April 7, 2015 No comments

SELECT COUNT(DISTINCT scheduler_id) AS TotalVisibleCores
FROM sys.dm_os_schedulers
WHERE scheduler_id < 1048576 — >= 1048576 = hidden