Categories:

SELECT
parent_node_id
,COUNT(*) as [Schedulers]
,SUM(current_tasks_count) as [Current]
,SUM(runnable_tasks_count) as [Runnable]
FROM sys.dm_os_schedulers
WHERE status = ‘VISIBLE ONLINE’
GROUP BY parent_node_id;

No responses yet

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.