Post reply

SQL 2005 - Get Deadlock information

  • March 25, 2013 at 9:56 am

    #275620

    IN sql 2005, I use DMV to get the number of deadlocks per sec. How can i get those deadlock's details? I havnt enabled the Traces or run profiler. These deadlocks already happend and i suspect if we could get the necessray details

  • March 25, 2013 at 10:36 am

    #1600414

    There's no way to get historical deadlocks in SQL 2005 unless you already had some traceflag or trace on at the time.

    To catch future deadlocks, turn traceflag 1222 on, the deadlock graph will then be written to the error log.

    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

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

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