sweep_regressions
Detect query regressions across all online databases with Query Store enabled, returning flagged regressions per database. Triage a whole SQL Server instance in one pass.
Instructions
Run regression detection across ALL online databases that have Query Store enabled, and return the worst regressions found per database. Use this to triage a whole instance instead of one database at a time.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| metric | No | Metric to evaluate regression against. | cpu_time |
| recent_hours | No | Length of the recent window, in hours. | |
| top_n_per_db | No | Max regressed queries to return per database. | |
| baseline_hours | No | Length of the baseline window, in hours. | |
| database_names | No | Optional explicit list of databases to sweep. If omitted, sweeps all Query Store-enabled online databases. | |
| min_executions | No | Ignore queries below this execution count. | |
| regression_threshold | No | Minimum fractional worsening to flag. |