check_statistics_health
Identify stale or outdated statistics with high modification counts and low sample rates, flagging those needing UPDATE STATISTICS.
Instructions
Check statistics health: stale stats, high modification counts, low sample rates. Flags stats needing UPDATE STATISTICS.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| stale_days | No | Flag stats not updated in this many days. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. | |
| mod_pct_threshold | No | Flag stats where modification_counter exceeds this % of rows. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||