Monitoring Locking and Blocking
SQL Server provides many different avenues for viewing and investigating locking problems. Locking may be investigated through sp_lock, sys.dm_tran_locks, SQL Profiler, PerfMon, and Extended Events, just to name a few.
Viewing Blocking with Management Studio Reports
With Management Studio, transaction information for a server or database may be seen using the Standard Reports, available from the server or database context menu, which pull data from the dynamic management views. The transaction-related reports include All Transactions, All Blocking Transactions (shown in Figure 47.2), Top Transactions by Age, Top Transactions by Blocked Transaction Count, Top Transactions by Lock Count, Resource Locking by Object, and User Statistics.
Viewing Blocking with Activity Monitor
Activity Monitor (see Figure 47.3) includes some useful bits of information that you can use to identify performance issues inside of SQL Server, including locking and blocking information. It's available on the toolbar and in the Object Explorer's server context menu.