Add columns has_victims and is_intra_query_deadlock to the event xml_deadlock_report
When working with deadlocks I have found that it would be useful to to have some columns added to the event xml_deadlock_report.
* has_victims - SQL Server sometimes generates large number of intra-query xml_deadlock_report - events with no victims, and no errors. It would be useful to be able to filter them out.
* is_intra_query_deadlock - Intra-query deadlocks where the process is aborted (getting an error) are rather serious bugs in SQL Server.
When working with Microsoft Support you are often asked for stack dumps. You can use extended events to generate stack dumps, but then it would be good to be able to filter on intra-query deadlocks.
Could this also help 3rd-party monitoring tools that can swamp deadlock occurrence lists with exchange-event deadlocks, which hide the real deadlocks we want to resolve in code? Solarwinds DPA for one. Hope this gets traction - we can start to see the wood for the trees.