slow-query-investigation
Use when one specific query got slow, changed plans, or swings from seconds to minutes with the same parameters. Has tested queries and rules common answers miss, e.g. Query Store averages need execution weighting. For many slow queries, use resource-usage-sqlserver.
Pinned to revision 3224561abf68, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/slow-query-investigation/SKILL.md
- skills/slow-query-investigation/references/azure-sql/guidance.md
- skills/slow-query-investigation/references/azure-sql/references/query-store-queries.md
- skills/slow-query-investigation/references/incident-evidence.md
- skills/slow-query-investigation/references/queries.md
- skills/slow-query-investigation/references/report-template.md
Every link opens the file at its source, pinned to the revision this page describes.