3 Replies Latest reply on Mar 27, 2015 3:46 PM by mandevil

    Does DPA blockers view show ALL blockers or just the ones that block for at least 1s ?

    karthikvijayakumar

      Hi,

       

      Does DPA blockers view show ALL blockers or just the ones that block for at least 1s ? I have application logs that lead me to believe there must be some blocking going on but I don't see that in the blockers view.

       

      Even in other situations with blockers listed, I have never seen any shown with less than 1s blocking time. None of the would be blockers took more a second to complete.

       

      We are on SQL Server 2012.

       

      Thanks,

      Karthik