Post reply

Lock eventing

  • May 27, 2004 at 7:47 am

    #82908

    Hi there!

    I'm looking for a stored procedure or existing method that logs and provides information on the processes and locks involved in a deadlock when it occurs.

    Does anyone know of such a procedure or method?

    Any help would be great!

     

  • May 28, 2004 at 7:49 am

    #508199

    dbcc traceon (1204,1205,1206, 3605) will print handful of deadlock related information to the errorlog. I don't think any customized SP, can do more than this unless you keep running server side profiler.

  • May 28, 2004 at 11:36 pm

    #508317

    Thanks for your help.

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

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