Skip to content

Instantly share code, notes, and snippets.

@LitKnd

LitKnd/current_blocked_query_waits_simple.sql

Created June 26, 2017 15:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save LitKnd/bc6ccefb8a8dfb20b90d22ef7e26d510 to your computer and use it in GitHub Desktop.
Save LitKnd/bc6ccefb8a8dfb20b90d22ef7e26d510 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
current_blocked_query_waits_simple.sql
select session_id,
wait_duration_ms / 1000. / 60. as wait_duration_min,
wait_type,
blocking_session_id
from sys.dm_os_waiting_tasks
where blocking_session_id is not null;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment