Posted By

tvanzele on 03/31/10


Tagged

sql DMV


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

Tyster
Beppoi


Wait stat list (user sessions)


 / Published in: SQL
 

  1. SELECT session_id
  2. , exec_context_id
  3. , wait_type
  4. , wait_duration_ms
  5. , blocking_session_id
  6. FROM sys.dm_os_waiting_tasks
  7. WHERE session_id > 50
  8. ORDER BY session_id, exec_context_id

Report this snippet  

You need to login to post a comment.