investigate-sql-memory-issues
Use when queries wait on memory grants (RESOURCE_SEMAPHORE), spill to tempdb, hit out-of-memory errors (701, 802, 8645), or PLE drops. 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-memory-issues/SKILL.md
- skills/investigate-sql-memory-issues/references/queries.md
- skills/investigate-sql-memory-issues/references/remediation-guide.md
- skills/investigate-sql-memory-issues/references/report-template.md
Every link opens the file at its source, pinned to the revision this page describes.