Azure SQL データベースがあります。 長時間実行されているクエリを特定する必要があります。ここでは、クエリ内のどの操作がパフォーマンスの問題を引き起こしているかを特定する必要があります。 Microsoft SQL Server Management Studio でクエリ実行プランを表示するために使用できるのは次のどれですか。
正解:A
With Live Query statistics, you get real-time information and insights on the queries as they are running. This allows you to debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finish. Option B is incorrect since this will only give you what could be the plan that is going to be used Option C is incorrect since this will not give live statistics that can show which query is causing an issue Option D is incorrect since this will not give the server stats that will show the performance of the queries https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-profiling- infrastructure?view=sql-server-ver15