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`.

Microsoft Updated 195k repo stars

File contents

microsoft/microsoft-sql commit a44e959db5

Frequently asked questions

npx get-skill add microsoft/slow-query-investigation