Live Query stats feature in SQL Server 2016 shows execution plan of a query in real-time.
This can be very
valuable for debugging long running queries. User will not have to wait for
query to complete to see where it’s spending most of time, it can be viewed while query is executing.
The live query stats
can be displayed for current session in SSMS by clicking on “Include Live Query
Stats” button.
The real time
information displayed includes
- % complete, both at overall query level and operator level.
- Elapsed time, for each operator.
- Number of rows processed for each operator so far (When you mouse over the operator).
No comments:
Post a Comment