🔥 3-day streak
Microsoft Azure Database Administrator Associate96 / 144
Question 96 of 144
You manage an Azure SQL Database that experiences intermittent slowdowns during peak hours. Users report that certain queries occasionally take much longer, but you cannot reproduce the issue on demand. You want to identify what resource the affected queries are waiting on (for example, CPU, locks, or memory) over time, grouped by query, without running a live trace during the incident. Which Query Store capability should you use?
Reviewed for accuracy · Report an issueNext question