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


54 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!

  2. I do not know whether it’s just me or if everyone else
    encountering issues with your blog. It appears like some of the text on your content are running off the screen.
    Can someone else please comment and let me know if this is happening to them too?

    This may be a problem with my browser because I’ve had this
    happen before. Many thanks

  3. great post, very informative. I’m wondering why the other specialists of this sector don’t understand this.
    You must continue your writing. I’m confident,
    you have a huge readers’ base already!

  4. I savour, cause I found just what I used to be looking for.

    You have ended my four day lengthy hunt! God Bless you man. Have a nice day.

  5. I know this web site presents quality based articles or
    reviews and extra data, is there any other web site which offers such things
    in quality?

  6. I appreciate, result in I discovered just what I used to be looking for.
    You have ended my 4 day lengthy hunt! God Bless you man. Have a great day.

  7. Howdy this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding experience so
    I wanted to get advice from someone with experience. Any help would be greatly appreciated!

  8. An interesting discussion is worth comment. I
    believe that you need to publish more on this topic, it may not be a taboo matter but generally folks
    don’t talk about such topics. To the next! All the best!!

  9. I am in fact delighted to glance at this webpage posts which includes plenty of useful information, thanks for providing these statistics.

  10. I savor, cause I found just what I used to be taking a look for.
    You’ve ended my four day long hunt! God Bless you man. Have a nice day.


  11. I don’t know if it’s just me or if everyone else experiencing
    issues with your website. It seems like some of the text within your content
    are running off the screen. Can somebody else please comment and
    let me know if this is happening to them as well?
    This could be a problem with my browser because I’ve had this happen previously.
    Many thanks

  12. I think that everything said was very reasonable.
    But, consider this, suppose you added a little content?
    I mean, I don’t wish to tell you how to run your website,
    however suppose you added a post title that makes people want
    more? I mean sp_WhatsupQueryStore v1.2 available – DotNine is kinda vanilla.
    You might glance at Yahoo’s front page and watch how they create post titles to get viewers interested.
    You might add a video or a pic or two to grab people interested
    about everything’ve got to say. Just my opinion, it would bring your blog a little bit more interesting.

  13. Thanks , I’ve recently been searching for information about this
    subject for ages and yours is the best I have found out so
    far. But, what in regards to the conclusion? Are you sure
    concerning the source?

  14. I have learn several excellent stuff here. Definitely price bookmarking for revisiting.
    I surprise how much effort you set to make this sort of wonderful informative site.

  15. necessary review. As well visit preferred site to
    find out game slot. Wonderful website has received great reputation together with slot pulsa online wagering men and women in Dalam negri.
    Presently there will be loads of elegant promos indoors event you actually join at
    the moment.

  16. whoah this blog is magnificent i love reading your articles.
    Stay up the good work! You understand, lots of
    people are searching around for this info, you could aid them greatly.

  17. Yala beybi kız lezbiyen; anne oğul vintage; hardcore fetiş;
    götten sikiş ek; üç zenci bir sarışın porno; en kötü porno
    filimleri; meltem ışık hain kadın; avrupa sex tv canlı izle; geyler sex;
    porno6 6; sallanan güzel götler sokunca titreten kusursuz; türkçe
    konuşma alt yazi; anal bebek; sert japon porno video; tyler nixon.

Write a Reply or Comment

Your email address will not be published.