advanced code snippet search

Posted By

tvanzele on 03/31/10


Tagged

sql DMV


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Wait stat list (user sessions)

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.