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

  • January 22, 2013 at 9:04 am

    #1579689

    bugg (1/22/2013)

    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.

    Started profiler now. Will update once ive captured a deadlock

    Profiler? That traceflag writes the deadlock graph into the SQL error log, not a trace event.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass