Sladescross's Blog

Blogging about Sharepoint related stuff

Blocking Chain (SQL Spackle) – SQLServerCentral September 19, 2013

Filed under: Blocking,SQL Server — sladescross @ 10:09 am

http://www.sqlservercentral.com/articles/Blocking/101926/

 

SQL Blocking March 5, 2010

Filed under: Blocking,Locking,SQL — sladescross @ 4:42 pm

http://support.microsoft.com/kb/224453/EN-US

  • Identify the SPID (Session ID) at the head of the blocking chain and the SQL Statement.
    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.
  •  

     
    Follow

    Get every new post delivered to your Inbox.

    Join 63 other followers