Post reply

How to find history of blocking batch/query?

  • March 4, 2015 at 5:27 am

    #295015

    Hello smart people,

    I see some time email say blocking took place and but it get resolved itself. so My question is, how to find the history of batch/query which blocked another SPID?

  • March 4, 2015 at 5:51 am

    #1781598

    It wouldn't unless you configure some customized sql job to store it manually in a table

  • March 4, 2015 at 6:00 am

    #1781600

    Thanks for your reply.

  • March 4, 2015 at 9:40 am

    #1781688

    Quick tip: the Data Collector can do that for you.

    -- Gianluca Sartori

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

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