SHARE
TWEET

ThreadPool Checks

SQLSoldier Aug 31st, 2016 78 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
Top