Use the Procedures 'with recompile' health check in Mini DBA to review Azure SQL Database configuration, metadata, and monitoring signals before they become active alerts.
This health check looks for design or query-pattern choices that can make execution plans harder to optimize and troubleshoot.
Plan quality problems often appear as intermittent performance incidents. This check helps you find the design issue while there is time to tune it deliberately.
Inspect the affected code path and recent execution plans. Prefer query rewrites, indexing, statistics fixes, and application changes over broad server settings unless the workload has been tested.
Keep a short note explaining why the check failed, what was changed, who owns the follow-up, and whether an exception was approved.
Prioritize it by blast radius. Fix it quickly when it affects a production workload, a shared server, or a customer-facing service; otherwise place it in the normal improvement backlog with an owner.
Prevent repeat failures by assigning an owner, documenting the expected configuration, and reviewing the check after upgrades, migrations, or major application releases.
Add this page to the operational runbook for Azure SQL Database environments where the check repeatedly fails. Record local thresholds, approved exceptions, escalation contacts, and the expected review interval so the next administrator can act quickly without rediscovering the same context.