Home Forums SQL Server 2008 SQL Server Newbies SQL Deadlocks RE: SQL Deadlocks

  • January 22, 2013 at 11:50 am

    #1579780

    anthony.green (1/22/2013)

    Do you have traceflag 1222 enabled?

    If so can you post the deadlock graph from the error log

    If not run

    DBCC TRACEON (1222, -1)

    and then post the graphs once a deadlock has occured.

    Hi Anthony

    I have this trace on but cant find the deadlock graph anywhere in the errorlog? The deadlock has been recorded but thats all.