As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.
I've added the following features:
- The query execution plan of the active request in the QueryPlan column to the right.
- Variable at the top which changes the relationship of the join between sys.dm_exec_sessions and sys.dm_exec_requests.
- When set to 0, this query now displays all sessions, even those without active requests. I recently found this helpful when researching sleeping sessions that were blocking active sessions.
- When set to 1, this query displays as it used to - only session and active request data.
- Percent_Complete column - great for finding the progress of backup and restores
- A few other minor helpful columns