Saturday, 6 May 2017

Check how many CPUs visible offline & online


--how many CPUs is SQL Server actually using

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


--how many CPUs are not being used

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


--how many CPUs an instance can see


select cpu_count from sys.dm_os_sys_info

No comments:

Post a Comment

Disable CDC at table level

 How to Disable CDC( Change Data Capture) for tables Change Data Capture (cdc) property is disabled as default.  here I will Query you how t...