# Blocking Analysis

> Analyze SQL blocking, deadlocks, lock waits, root blockers, affected AX tables, and recommended low-risk remediation.

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

---


# Blocking Analysis

Use this skill when evidence includes `blocking.csv`, `deadlock_processes.csv`, lock waits, or deadlock XML.

## Workflow

1. Parse deadlock XML with `scripts/parse_deadlock_xml.py` when needed.
2. Analyze lock waits and blocking findings with `scripts/analyze_evidence.py`.
3. Map blocked objects to AX tables and owners.
4. Recommend schedule separation, transaction-scope review, or targeted code/query review.

## Guardrail

Do not recommend isolation-level or `NOLOCK` changes casually. Require risk and validation notes.