Home Forums SQL Server 2005 Administering How to detect dead lock from SQL Server side RE: How to detect dead lock from SQL Server side

  • June 12, 2008 at 1:00 am

    #827668

    If You are using SQL 2005 there is an Event Notification that can be used -DEADLOCK_GRAPH

    you can use Service Broker to log every deadlock info into table ,information is complete and useful.

    Ivan