What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

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)?
A . Live Query Statistics
B . an estimated execution plan
C . an actual execution plan
D . Client Statistics

Answer: A

Explanation:

https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/

Latest DP-300 Dumps Valid Version with 176 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments