search

opserver / Opserver

Stack Exchange's Monitoring System
https://opserver.github.io/Opserver/
MIT License
4.5k stars 827 forks source link

SQL - indicate if Query has Missing Index recommendation #314

Open elvishfiend opened 6 years ago

elvishfiend commented 6 years ago

A quick way to tell that a query may be tuneable is if there's a Missing Index recommendation in the SqlPlan.

There's currently no indication of this either in the SQL Top Queries page or on the Query Detail itself, but it would be helpful to at least have an icon on the Top Queries page showing that there's something worth looking into. (I know that Index recommendations can be junk - that's why I'm only suggesting an icon)

NickCraver commented 6 years ago

Are you picturing an icon on the individual query results, or on the main listing? Just trying to understand the desire here. On the main listing would be very costly, as it would require bringing back the entire pain and shredding the XML to determine the boolean. In the detail window: it's much more doable.

elvishfiend commented 6 years ago

I had originally pictured it on the main listing - but then I went and had a look at doing it myself, and I see what you mean about the pain. I think having it in the Query Detail will be a big enough win - you see a slow plan, you open it, "Possible Missing Index!"