How many CPU’s does SQL see

Estimated Reading Time: < 1 Minute

178 Natural Networks NOC January 10, 2015 Microsoft SQL Server 0 3.13K

select scheduler_id, cpu_id, status, is_online
from sys .dm_os_schedulers
where status = ’VISIBLE ONLINE’

select cpu_count from sys. dm_os_sys_info

Did you find this article helpful?

How many CPU’s does SQL see

Estimated Reading Time: < 1 Minute Natural Networks NOC January 10, 2015 0 3.13K

COMMENT