15
Dec 2016
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.
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: //github.com/Evdlaar/sp_WhatsupQueryStore
49 comments to “sp_WhatsupQueryStore v1.2 available”
This article will assist the internet visitors for setting up new blog
or even a blog from start to end.
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!
My relatives always say that I am killing my time here at web, but I know
I am getting familiarity daily by reading thes nice articles.
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
I am actually pleased to read this webpage posts which carries plenty of useful facts,
thanks for providing these information.
Wow, that’s what I was seeking for, what a stuff!
present here at this webpage, thanks admin of this
web site.
Why users still use to read news papers when in this
technological world everything is available on net?
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!
I read this article fully on the topic of the comparison of hottest and preceding technologies,
it’s remarkable article.
I am truly grateful to the holder of this website who
has shared this wonderful paragraph at at this place.
Wonderful, what a website it is! This weblog presents useful information to us, keep it up.
Now I am going to do my breakfast, afterward having my breakfast coming again to read additional news.
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.
Bye
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?
Quality articles or reviews is the secret to interest the visitors to go
to see the web page, that’s what this site is providing.
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.
Bye
Thanks for finally writing about > sp_WhatsupQueryStore v1.2 available – DotNine < Loved it!
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!
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!!
I pay a quick visit daily a few blogs and sites to read articles or reviews,
except this blog gives feature based articles.
What’s up mates, pleasant post and pleasant urging
commented here, I am in fact enjoying by these.
I am in fact delighted to glance at this webpage posts which includes plenty of useful information, thanks for providing these statistics.
Fine way of explaining, and good post to get
facts regarding my presentation focus, which i am going
to present in academy.
Hi Dear, are you really visiting this web site on a regular basis, if so afterward you will absolutely take pleasant know-how.
Article writing is also a fun, if you be familiar with then you can write if not it is complicated to write.
Hi colleagues, its fantastic post on the topic of educationand completely defined, keep it up all the time.
I am regular visitor, how are you everybody?
This article posted at this web site is in fact pleasant.
Hi there everyone, it’s my first pay a visit at this web site,
and paragraph is in fact fruitful in favor of me, keep up posting these posts.
This post will assist the internet viewers for setting up new blog or even a weblog from start to
end.
At this moment I am going away to do my breakfast, after
having my breakfast coming over again to read additional news.
I am in fact glad to read this blog posts which contains plenty of useful facts, thanks for providing such data.
Hello, after reading this amazing post i am too delighted to share my know-how here
with mates.
Hi, its nice piece of writing about media print, we
all be familiar with media is a great source of facts.
I am in fact delighted to read this webpage posts which consists of plenty
of valuable information, thanks for providing such data.
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.
Bye
Thanks in support of sharing such a pleasant thinking,
piece of writing is nice, thats why i have read it entirely
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
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.
I know this web site provides quality dependent articles or reviews and other information, is there
any other web site which offers such data in quality?
Hello, I desire to subscribe for this weblog to take latest updates,
so where can i do it please help.
Hello to every body, it’s my first pay a quick visit of this weblog; this web site contains remarkable and actually
fine stuff for visitors.
Hi to every one, it’s really a pleasant for me to visit this website,
it includes precious Information.
I know this website presents quality dependent content and other data, is there any other web site which gives these kinds of data in quality?
Thanks for finally talking about > sp_WhatsupQueryStore v1.2 available – DotNine < Loved it!
Hello everyone, it’s my first pay a visit at this web site, and post is really fruitful for me, keep up posting these articles
or reviews.
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?
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.
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.