Advertisement
SQLSoldier

ThreadPool Checks

Aug 31st, 2016
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. Select S.cpu_id, count(*)
  2. From sys.dm_os_threads As T
  3. Inner Join sys.dm_os_schedulers As S On S.scheduler_address = T.scheduler_address
  4. Group By S.cpu_id;
  5.  
  6. Select S.parent_node_id, count(*)
  7. From sys.dm_os_threads As T
  8. Inner Join sys.dm_os_schedulers As S On S.scheduler_address = T.scheduler_address
  9. Group By S.parent_node_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement