Without a doubt Query Store and the GUI front end in Management Studio are fantastic for digging into queries which misbehave and go bump in the night, or any other time of day. However, like the host of that late night informercial, Microsoft could easily say “but wait, there’s more.” Did you know that feeding those lovely Query Store windows are a bunch of DMVs? Did you know that you can query those DMVs? By the end of this session you will be able to query those underlying DMVs to find plans with:
• Plan affecting implicit conversions
• Key or RID lookups
• Missing Indexes
Further more you will be able to gather other data to help prioritize which of your problem child queries you need to pay attention to first and which can wait until later, all by shopping at the query store.