Question 960
An Azure SQL database experiences intermittent latency and operations wants top resource-consuming queries over time. The team is considering this step: Analyze top statements and correlate plan/runtime changes with traffic. What evidence should they review before proceeding?
Explanation
Correct Answer
Check supported monitoring view, Query Store data and relevant time window. Azure SQL query insights and Query Store can reveal resource-heavy query trends.
Incorrect Answers
Daily mean CPU masks transient spikes and cannot map symptoms to procedures. Compare time-bounded Query Store statements and plans.
Query text alone cannot demonstrate a plan regression. Inspect Query Store plan IDs, execution distributions and release timing.
Development estimates may not reflect production cardinality or traffic. Correlate actual workload windows and runtime statistics.