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;
Categories:
Tags:
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;
Tags:
No responses yet