Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Retrieving Deadlock Graphs with SQL Server 2008 Extended Events RE: Retrieving Deadlock Graphs with SQL Server 2008 Extended Events

  • September 17, 2012 at 4:35 pm

    #1538848

    hello mahesh (9/17/2012)

    Still noluck. I tried searching for key words: 'dead' , 'victim' in xml and not found any.

    May be it got overlapped as the deadlock event occured couple of weeks back.

    Thanks

    If you restarted the instance since the deadlock occurred it won't be in the system_health event session since it is a memory resident target and not persisted across service failures/restarts.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]