sqldeadlock-review skillA
sqldeadlock-review is agent-read markdown (skill) from vanterx/mssql-performance-skills: Analyze SQL Server deadlock XML (from system_health XE session, SSMS deadlock graph, or trace) to identify root cause and produce a prioritized remediation plan. Applies 17 known deadlock patterns (P1–P17). Use when a deadlock monitor captures a graph or users report intermittent deadlock errors (error 1205)..
Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.
What the file says
# SQL Server Deadlock Analysis Skill
## Purpose
Parse a SQL Server deadlock XML graph, identify the victim and winner processes, extract the queries and lock acquisition patterns involved, match against 17 known deadlock patterns (P1–P17), and produce a prioritized remediation plan.
## Input
Accept any of:
- Raw `<deadlock>` XML (from system_health XE session or SSMS deadlock graph Save As XML)
- A file path to a `.xdl` or `.xml` deadlock graph file
- A description of the deadlock if XML is not available
## How to Run
1. Parse the XML structure
2. Extract process list (victim, winner, their queries, lock waits)
3. Extract resource list (what locks are held and requested)
4. Match against pattern library
5. Generate remediation recommendations
---
## XML Structure Reference
```xml
<deadlock>
<victim-list>
<victimProcess id="process1a2b" />
</victim-list>
<process-list>
<process id="process1a2b" taskpriority="0" logused="0"
waitresource="KEY: 5:72057594038910976 (abc123)"
waittime="4023" ownerId="123456"
transactionname="user_transaction"
currentdb="5" spid="52" kpid="1234"
…Read the whole file at its exact version.
How to install
mdr add vanterx/mssql-performance-skills/sqldeadlock-review@git:20260919.8a7bf7emdr add vanterx/mssql-performance-skills/sqldeadlock-review@sha256:e98c82262447edb2Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.
[](https://markdownregistry.com/a/art_imjcseefh26shs47)
1 badge views in 30 days
Versions
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20260919.8a7bf7e latest | 2026-09-19 | 8a7bf7e | 22,594 B | A | view · diff |
| git:20260705.6d391a9 | 2026-07-05 | 6d391a9 | 22,287 B | A | view · diff |
| git:20260605.9ec0ebe | 2026-06-05 | 9ec0ebe | 20,388 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (22594 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
vanterx/mssql-performance-skills · 5 stars · license MIT · pushed 2026-09-19 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_imjcseefh26shs47 GET https://markdownregistry.com/api/v1/resolve?ref=vanterx/mssql-performance-skills/sqldeadlock-review GET https://markdownregistry.com/api/v1/blob/e98c82262447edb2f2682468d80bb9894db180a09cdef7ebe2f3a8c4df6fc61a
Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.