• GilaMonster (1/9/2013)


    There's no permanent store of deadlocks that have occurred unless you have created one.

    You can't get the ' list of deadlocks available in the server' because there's no such thing. SQL does not store deadlock information for long periods. Prior to SQL 2008, it didn't store it at all. If you want to track deadlocks, you need either a custom trace or a custom extended events session or a traceflag and archiving of the error logs.

    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