SQL Blocking March 5, 2010
In addition to using the scripts in the previously mentioned Knowledge Base article, you can identify the head of the blocking chain by using features that are provided through SQL Server Management Studio. To do this, use one of the following methods:
- Right-click the server object, expand Reports, expand Standard Reports, and then click Activity – All Blocking Transactions. This report shows the transactions at the head of blocking chain. If you expand the transaction, the report will show the transactions that are blocked by the head transaction. This report will also show the “Blocking SQL Statement” and the “Blocked SQL Statement.”
- Use DBCC INPUTBUFFER(<spid>) to find the last statement that was submitted by a SPID.