Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 21 March 2017

How many CPU cores is SQL Server using?

How many CPU cores is SQL Server using?

CPU count:

select cpu_count from sys.dm_os_sys_info


How many CPU cores is SQL Server using:

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