I need some help with deadlock situation

I need some help in deadlock situation I want to know the details of which session due to which victim session got killed. SQL monitor is giving the details of victim session but not the culprit session due to which deadlock occurs and one session got killed

Answers

  • Alex BAlex B Posts: 1,153 Diamond 4
    Hi @ssh4478,

    Which version of SQL Monitor are you currently using?  And which alert type is it - Deadlock or Deadlock (extended event)?

    Are you able to share a screenshot of what you are seeing where it only shows one portion of the deadlock details? 

    The details of both should be available.  If you are seeing the graphical representation laying out the deadlock, then you can click on each process to populate the box at the side with the details of that process.  You should also be able to click on the Output tab on the Alert details page to view the XML of the deadlock graph to see the information sampled there as well.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.