TempDB And I/O Analysis
Use this skill for TempDB, file latency, PAGEIOLATCH, WRITELOG, spills, and storage pressure.
Workflow
- Review
tempdb_usage.csv,file_latency.csv, waits, and plan spill warnings. - Correlate with batch/report windows and high-read query families.
- Recommend validation of file layout, storage latency, query spills, and maintenance overlap.
Related Scripts
analyze_evidence.pyparse_plan_xml.pyforecast_capacity_exhaustion.py