Live Query Statistics In SQL Server 2016 CTP 2.0

Hi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016.

It’s a common scenario in our day-to-day life that queries takes longer time to execute and we are waiting for its completion so that we can check the actual execution plan to check the operators to improve the performance. So friends this is overcome now in SQL Server 2016.

In SQL Server 2016 we get the new facility to view the live execution plan of a current executing query and can check which steps are currently being performed. This feature is very helpful in debugging issues related to performance displaying overall query progress and run-time statistics for query plan operators.

How to get it enabled?

There are two ways to get this feature enabled:

First, by clicking on icon of Live Query Statistics as shown in figure.

LiveQueryStatistics_2

Another one, is selecting the query and then Right click on it to select option Include Live Query Statistics. No shortcut key is currently assigned to enable Live Query Statistics option.

LiveQueryStatistics_3

Now, I will execute a query to see the live execution plan.

SELECT * FROM sales.salesorderdetails S

INNER JOIN Production.Product P ON P.ProductId = S.ProductId

LiveQueryStatistics_1

Here, I can view in my live execution plan that query plan operators are currently in progress and continuously changing values until execution of query gets completed.

That’s all folks for the day!!

Regards,

Kapil Singh Kumawat

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook 

Avatar

About Kapil Singh Kumawat

Kapil Singh Kumawat has been working with SQL Server since last 5 years. He is from Jaipur, Rajasthan, India and currently working with Cognizant Technology Solutions as SQL Server Developer. He has good experience in performance tuning, SSIS, data migration and data designing. Apart from database he has interest in travelling, watching football and listening music.

View all posts by Kapil Singh Kumawat →

Leave a Reply

Your email address will not be published. Required fields are marked *