Blocking Analysis
Use this skill when evidence includes blocking.csv, deadlock_processes.csv, lock waits, or deadlock XML.
Workflow
- Parse deadlock XML with
scripts/parse_deadlock_xml.pywhen needed. - Analyze lock waits and blocking findings with
scripts/analyze_evidence.py. - Map blocked objects to AX tables and owners.
- 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.