Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

12 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • SAinCA commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base