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)?
To identify which operation in a query is causing performance issues in an Azure SQL database, you should use an actual execution plan in Microsoft SQL Server Management Studio (SSMS). The actual execution plan provides detailed information generated by the SQL Server engine during the execution of the query, including the actual number of rows processed, the actual resource consumption, and potential issues like missing indexes or inefficient operations. This information is valuable for pinpointing the exact causes of performance problems in a complex query.
Live Query Statistics
Its supposed to be C.
Should be C
Key is Long Running Query, So use Live Query Statistics
However, for identifying a long-running query and analyzing its execution in real-time, the best choice would be the actual execution plan. This option allows you to see the actual query plan generated by the SQL Server engine during query execution, including the actual number of rows, actual resource consumption, and any potential issues such as missing indexes or inefficient operations.
https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/
ChatGPT answer - C. An actual execution plan