SQL Server 2016 Live Query Statistics
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the new features inside SQL Server 2016. You can download SQL Server 2016 CTP2 here: //www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
While I was playing around with all the new features inside SQL Server 2016 (especially Query Store, and some new reports associated with the Query Store, expect a blog post on all that awesomeness), I noticed an extra icon inside the SQL Server 2016 Management Studio.
Include Live Query Statistics…looks like a missed a new feature. It sounded pretty awesome to me so I enabled the option and ran a (simple) query just to check what it does. While the query was running SQL Server Management Studio immediately opened a new tab in the Results window called “Live Query Statistics”.
Now I didn’t notice anything else new except for some extra information underneath the Execution Plan operators and a nice box drawn around the query at the top of the window…That was kind of a disappointment…
The disappointment quickly faded though when I ran a much larger query against an enlarged AdventureWorks database!
Look at that thing going! Through Live Query Statistics you can see how long operators are taking, how far they are in their operations and get some awesome animation.
Off course the thing isn’t perfect. For instance, you can only use it on queries you are executing yourself inside SSMS, and if row estimated are not correct the percentage calculation won’t work on the operators (it will get stuck on 100% while the time keeps ticking away).
I am guessing we will learn more about Live Query Statistics after everyone had some more time to play around with it. So far, I am liking it, not only because your actually watching your query get executed, but also because you can detect expensive operations by just looking at the animation!
11 comments to “SQL Server 2016 Live Query Statistics”
Thanks , I have just been searching for information about this subject for a
long time and yours is the greatest I’ve came upon till now.
But, what concerning the bottom line? Are you positive in regards to the source?
What’s Happening i’m new to this, I stumbled upon this I have found It positively helpful and it has helped
me out loads. I’m hoping to give a contribution & help different customers like its helped me.
Good job.
I delight in, lead to I discovered just what I was having a look for.
You’ve ended my four day long hunt! God Bless you man. Have a great
day. Bye
Attractive element of content. I simply stumbled upon your web site and in accession capital to assert that I get in fact
loved account your blog posts. Anyway I will be subscribing on your augment
and even I fulfillment you get right of entry to constantly fast.
If you would like to improve your experience just keep visiting this web page and be updated with the newest news posted here.
What’s up to every , because I am truly keen of reading this weblog’s
post to be updated regularly. It carries nice material.
Really no matter if someone doesn’t know then its up to other people that they will assist, so
here it takes place.
Marvelous, what a webpage it is! This webpage presents useful information to us, keep it up.
It’s truly very complicated in this full of activity life to listen news on TV, therefore I simply
use the web for that reason, and take the newest news.
I read this post completely about the difference of most up-to-date and preceding technologies, it’s
amazing article.
It’s nearly impossible to find knowledgeable
people on this subject, but you seem like you know what
you’re talking about! Thanks