Post reply

Blocking issue.

  • March 26, 2008 at 3:06 pm

    #120602

    Hi Guys

    Really what does this means in usage of SP_WHO2 OR SP_WHO

    in status column --Sleeping (how to interprete Sleeping) and in blk by column it is shoewng same id,

    how we can interprete it to better understand.

    sleeping, and it's blocked on 58 (itself?). What does this mean? Is there any way to find out what is causing it to block?

  • March 26, 2008 at 3:44 pm

    #794369

    You can run SQLDiag.exe to give you detailed locking/blocking/process info.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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