Post reply

Query to find a blocing id/ spid

  • January 19, 2010 at 2:30 am

    #215804

    How can we find an id/ spid which is blocking some other transaction using a query?

  • January 19, 2010 at 2:39 am

    #1105290

    select session_id, blocking_session_id from sys.dm_exec_requests

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 19, 2010 at 3:18 am

    #1105299

    Thanks.Appreciated.

  • January 19, 2010 at 3:35 am

    #1105303

    sp_who2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply