Question

You manage an Azure SQL Database supporting a line-of-business application. Users report intermittent slowness during business hours, but performance seems normal when you check it. Before making any configuration or index changes, your manager asks you to quantify what 'normal' performance looks like over a two-week period so future changes can be measured against it. Which approach best establishes this reference for comparison?

Accepted Answer

Capture a performance baseline by collecting key metrics (CPU, DTU/vCore usage, I/O, and query durations) over a representative period and store them for comparison.

Answer

Enable automatic tuning so the database self-corrects any performance issues without manual analysis.

Answer

Run a one-time Extended Events session for 30 minutes during a slow period and use those results as the standard.

Answer

Force the last good execution plan for the most expensive query in Query Store.