How to monitor actitvity in a MS SQL Server
...and find out everything you ever wanted to know about slow queries or locks.
Open SQL Management Studio and then in the context menu of your database server the Activity Monitor:
USE Master GO EXEC sp_who2 GO
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.
Use the context menu to get the query text or see the execution plan
Example Query Text
Example Execution Plan