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.