Multi-victim deadlock in SQL Server I have been seeing a lot of deadlocks occurring on a system with deadlock graphs similar to this one:



I have been advised that it is a multi-victim deadlock but I cannot re-create a deadlock graph such as this one. Also, why does it only show one victim?

Any help or advice would be most appreciated.

Andrew
I suppose this graph is coming out of SQL Profiler. Profiler behaves this way. it cannot display multi-victim deadlocks correctly. If you pick the very same deadlock from the system_health extended events session (no extra trace necessary as this one is running by default), you can get the correct visual within Extended Events Viewer.
Also you can use this link to get a free deadlock collector and parser which also gets that information and the graphs: https://sqldeadlockcollector.codeplex.com/


as requested: yes, I am the person who created the deadlock collector which is free for anyone to download&amp;use