Post reply

Is it possible to record when a blocking lock occurs?

  • February 2, 2009 at 8:47 am

    #936477

    What an innovative idea - thanks! 🙂

  • February 2, 2009 at 11:02 am

    #936601

    Erm ... If the process is blocked it can not do anything ... putting code in the blocked procs would not work.


    * Noel

  • February 2, 2009 at 2:59 pm

    #936770

    Erm ... If the process is blocked it can not do anything ... putting code in the blocked procs would not work.

    I didn't think that one all the way through :blush:.

    You could, however, add timing information through out the stored proc and identify which parts of the proc have inconsistent timing thus indirectly finding objects possibly have blocking issues. You could also, prior to running any of the code in the sp, check to see if there are any locks on the objects that the sp would be using/changing.

    none of these are a perfect solution but if used in conjunction with some of the polling suggestions above you could probably get indication as to which procs have blocking issues.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

Viewing 3 posts - 16 through 17 (of 17 total)

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