Advanced Search

Wait stat list (user sessions)

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.