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?

45 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Brent Ozar shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: oidc
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