# Tempdb Io Analysis

> Analyze TempDB pressure, file latency, PAGEIOLATCH/WRITELOG waits, spills, and storage-related AX performance risk.

- Skill: `rweisssieker-xp/tempdb-io-analysis` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/tempdb-io-analysis`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/tempdb-io-analysis/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/tempdb-io-analysis

---


# TempDB And I/O Analysis

Use this skill for TempDB, file latency, PAGEIOLATCH, WRITELOG, spills, and storage pressure.

## Workflow

1. Review `tempdb_usage.csv`, `file_latency.csv`, waits, and plan spill warnings.
2. Correlate with batch/report windows and high-read query families.
3. Recommend validation of file layout, storage latency, query spills, and maintenance overlap.

## Related Scripts

- `analyze_evidence.py`
- `parse_plan_xml.py`
- `forecast_capacity_exhaustion.py`