tigertoolbox/Running-Blocked-Processes

Purpose: Returns a snapshot on running sessions/requests; blocking information; sessions that have been granted locks or waiting for locks; SPs stats.

In the output, you will find the following information in 4 sections:

• Uptime Information
• Running Sessions/Requests Report including resource usage, running statement, execution plan, blocking resource, waits and other relevant information.
• Waiter and Blocking Report, including information on head blocker and blocking chains.
• Stored procedure execution statistics.