BlockingQueries.sql

SELECT
    blocking.session_id         AS blocking_session,
    blocked.session_id          AS blocked_session,
    blocked.wait_type,
    blocked.wait_time / 1000.0  AS wait_seconds,
    blocked.status,
    sq.text                     AS blocked_sql,
    bsq.text                    AS blocking_sql
FROM sys.dm_exec_requests AS blocked
JOIN sys.dm_exec_sessions    AS blocking
    ON  blocking.session_id = blocked.blocking_session_id
JOIN sys.dm_exec_connections AS bc
    ON  bc.session_id = blocking.session_id
CROSS APPLY sys.dm_exec_sql_text(blocked.sql_handle)         AS sq
CROSS APPLY sys.dm_exec_sql_text(bc.most_recent_sql_handle)  AS bsq
WHERE blocked.blocking_session_id > 0;