Blocking Session Information

  • Hi

    I know it isn't possible to retrospectively get information on sessions that were being blocked, is there a way to get SQL server to write to a table or something when it detect that there's a session being blocked?

  • This article describes a couple of methods to monitor blocking, but keep in mind that blocking is a normal function of isolation and locking, and you should really only be concerned when wait times exceed a certain threshold.

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

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 2 posts - 1 through 1 (of 1 total)

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