Advertisements
Home > Optimization Performance, SQL Server 2016 > See Execution Plans running with Live Query Statistics – SQL Server 2016

See Execution Plans running with Live Query Statistics – SQL Server 2016


In SQL Server 2016 Live Query Statistics is going to be the most used feature among Developers & DBAs to check the live Execution Plan of an active Query running in parallel.
 

The Live Query/Execution Plan will provide Real-time insights into the Query Execution process as the Control flows from one Operator to the another. It will display the overall Query Progress and Operator-level Run-time Execution Stats such as:

1. Number of Rows processed

2. Completion Estimate

3. Operator progress – Elapsed time & Percentage done for each Operator

4. Elapsed time & Percentage done for overall Query progress
 

–> The feature can be enable from the Toolbar, just besides the “Actual Execution Plan” icon:

SQL Server 2016 - Live Query Stats - SSMS
 

–> The Live Execution plan running can be seen in below animated image:

SQL Server 2016 - Live Query Stats

The dotted moving lines above shows the Operators currently in execution. As soon as the Operator finishes execution these dotted lines will change to solid lines.
 

Thus, by using this feature the user will not have to wait for a Query to complete its execution and then see the Execution plan stats. As soon as the user will run the Query, the Live Execution Plan will also start showing all the Operators and their progress. This will help users in checking the long running queries where actually they are taking time, and help debugging Query performance issues.
 

You can also check the full demo here in this video:

SQL Server 2016 - Live Query Stats - YouTube


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: