...and find out everything you ever wanted to know about slow queries or locks.

Prepare

Open SQL Management Studio and then in the context menu of your database server the Activity Monitor:


Overview


Blocked Processes

USE Master
GO
EXEC sp_who2
GO
CODE

A list of processes will be displayed, and any processes which are currently in a blocked state will display the SPID of the processes blocking them in the ‘BlkBy’ column.

Expensive Queries

Use the context menu to get the query text or see the execution plan


Example Query Text

Example Execution Plan