To view the live query execution plan, on the tools menu click the Include Live Query Statistics icon. You can also view access the live query execution plan by right-clicking on a selected query in Management Studio and then click Include Live Query Statistics.
What can be done using the live query statistics tool?
Live Query Statistics is a feature introduced in SQL Server 2016. It provides you with a live execution plan which displays overall query progress and run-time execution statistics such as elapsed time, operator progress, number of rows processed and so on.
How do I check SQL query status?
- Right-click the SQL Server instance node and select Activity Monitor, or.
- Press Ctrl+Alt+A, or.
- Click the Activity Monitor icon in the menu.
