sp_WhatsupQueryStore v1.2 available

sp_WhatsupQueryStore v1.2 has just been released!
In this new version additional parameters are added to control what information is returned and a change has been made to the information that is returned by default.


  • Changed what information is returned by default when no additional parameters are supplied.
    In the previous versions of sp_WhatsupQueryStore all information was returned when no parameters were supplied.
    In this new version the default changed to return nothing if no parameters are supplied.
    This means that if you want to see all the information you have to set all the @return_ parameters to ‘1’ or use the new
    parameter @return_all and set it to ‘1’.

The reason for this change was the possible impact and runtime of the sp_WhatsupQueryStore stored procedure.
By limiting the results by default the impact is smaller and runtime is reduced to only the checks you explicitly specified.

  • Additional columns returned for the multiple plans selection:
    • Plan ID
    • Last Execution Time
    • Query Text
    • Engine Version
    • Compatibility Level
  • Added new parameter @show_query_hints.
    If @show_query_hints is set to ‘1’ the “Queries with multiple plans” window returns the SQL command as XML you can run to force the
    selected execution plan for the selected query through the Query Store.
    WARNING: Think carefully before you force execution plans since it can negatively impact the performance of your queries!

As always, you can download sp_WhatsupQueryStore from it’s GitHub page at: //github.com/Evdlaar/sp_WhatsupQueryStore


3 comments to “sp_WhatsupQueryStore v1.2 available”

You can leave a reply or Trackback this post.
  1. You truly make these kinds of seem easy with your screen but I actually
    find such a matter to be actually a thing that I think I want to
    never figure out. It seems as well complex and incredibly broad singularly.
    I am looking forward for your forthcoming post, I actually is able
    to try to get accustomed to it!

Leave a Reply to Savannah Cancel reply

Your email address will not be published.