investigate-sql-cpu-pressure
Use when CPU is high on SQL Server or Azure SQL (alerts, throttling, SOS_SCHEDULER_YIELD waits) and the user wants the queries responsible. For a broad resource snapshot, 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/investigate-sql-cpu-pressure/SKILL.md
- skills/investigate-sql-cpu-pressure/references/plan-smell-reference.md
- skills/investigate-sql-cpu-pressure/references/report-template.md
- skills/investigate-sql-cpu-pressure/references/step-3-active-offenders.md
- skills/investigate-sql-cpu-pressure/references/step-4-historical-plan-cache.md
- skills/investigate-sql-cpu-pressure/references/step-4-query-store-cpu.md
- skills/investigate-sql-cpu-pressure/references/step-5-memory-grants-spills.md
- skills/investigate-sql-cpu-pressure/references/step-6-plan-smells.md
- skills/investigate-sql-cpu-pressure/references/step-7-query-text-and-plan-analysis.md
Every link opens the file at its source, pinned to the revision this page describes.