How can we improve Azure SQL Database?

Include improved & regressed query plan links in sys.dm_db_tuning_recommendations

When you enable Automatic Index Tuning, and Azure adds indexes, the portal's validation screen shows a count of the number of improved and regressed queries. However, there's no easy way to tell which queries they were.

To facilitate that, how about in the "details" JSON column of sys.dm_db_tuning_recommendations, you add something to help us join to Query Store or the plan cache to see which queries they were?

42 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Brent Ozar shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

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

        Would be much better and save lots of time if it expanded to tell you what was better and what was worse otherwise it is just a guessing game.
        This is similar to the issue of the truncation error and working out which of your columns was the cause before this info was added.

      Feedback and Knowledge Base