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'
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'
No comments:
Post a Comment