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.
Releasenotes:
- 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: https://github.com/Evdlaar/sp_WhatsupQueryStore
