You have an Azure SQL database. You identify a long running query. You need to identify which operation in the query is causing the performance issue. What should you use to display the query…

The correct answer is A. Live Query Statistics. SQL Server Management Studio provides the ability to view the live execution plan of an active query. This live query plan provides real-time insights into the query execution process as the controls flow from one query plan operator to another. The live query plan displays the…

Submitted by fatema_kw· Mar 6, 2026Optimize query performance

Question

You have an Azure SQL database. You identify a long running query. You need to identify which operation in the query is causing the performance issue. What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

Options

ALive Query Statistics
Ban estimated execution plan
Can actual execution plan
DClient Statistics

How the community answered

(51 responses)

A
88% (45)
B
2% (1)
C
8% (4)
D
2% (1)

Explanation

SQL Server Management Studio provides the ability to view the live execution plan of an active query. This live query plan provides real-time insights into the query execution process as the controls flow from one query plan operator to another. The live query plan displays the overall query progress and operator-level run-time execution statistics such as the number of rows produced, elapsed time, operator progress, etc. Because this data is available in real time without needing to wait for the query to complete, these execution statistics are extremely useful for debugging query performance issues. https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice