How many CPU’s does SQL see

HOW MANY CPU’s ARE ONLINE FOR SQL:

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

 

HOW MANY CPU’s DOES SQL SEE:

select cpu_count from sys. dm_os_sys_info

Article ID: 178
Created: January 10, 2015
Last Updated: January 10, 2015
Author: Natural Networks NOC [support@naturalnetworks.com]

Online URL: https://kb.naturalnetworks.com/article.php?id=178