sqltrace-review skillA
sqltrace-review is agent-read markdown (skill) from vanterx/mssql-performance-skills: Analyze SQL Server trace files and Extended Events output to identify workload-level performance patterns. Applies 25 checks (X1–X12 event-level, X13–X25 workload aggregate) covering long-running queries, high-frequency N+1 patterns, parameter sniffing signals, recompilations, lock timeouts, hash/sort warnings, top resource consumers, and SQL 2019/2022 modern feature events. Use when a user provides Profiler trace output, sys.fn_trace_gettable() results, or Extended Events session data..
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 Trace / Extended Events Review Skill ## Purpose Analyze workload-level diagnostic data from SQL Server Profiler traces (`.trc`), Extended Events sessions (`.xel`), `sys.fn_trace_gettable()` output, or XE session query results. Produce a ranked summary of top resource consumers and a prioritized findings report covering 25 checks (X1–X25) across event patterns and cross-event workload aggregates. Trace analysis reveals patterns that no single-query artifact can show: which queries run thousands of times per minute, which have wildly inconsistent durations (parameter sniffing), how many recompilations are happening globally, and whether spill or lock events correlate with slow periods. ## Input Accept any of: - `sys.fn_trace_gettable()` query results — paste the tabular output (tab-separated, CSV, or grid) - Extended Events session query results — any column layout containing event name, SQL text, duration, CPU, reads - SSMS Profiler trace grid — copy-paste from the trace window - A `.trc` or `.xel` file path (describe what to extract if the file cannot be read directly) …
Read the whole file at its exact version.
How to install
mdr add vanterx/mssql-performance-skills/sqltrace-review@git:20260618.5cdc14amdr add vanterx/mssql-performance-skills/sqltrace-review@sha256:72fb0ce8099ab023Pin 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_dy4jkydlrupjrmtk)
1 badge views in 30 days
Versions
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20260618.5cdc14a latest | 2026-06-18 | 5cdc14a | 27,694 B | A | view · diff |
| git:20260618.bc5c50b | 2026-06-18 | bc5c50b | 27,699 B | A | view · diff |
| git:20260607.6ff4f7a | 2026-06-07 | 6ff4f7a | 27,699 B | A | view · diff |
| git:20260605.9ec0ebe | 2026-06-05 | 9ec0ebe | 27,400 B | A | view · diff |
| git:20260603.6f65dab | 2026-06-03 | 6f65dab | 27,412 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 (27694 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_dy4jkydlrupjrmtk GET https://markdownregistry.com/api/v1/resolve?ref=vanterx/mssql-performance-skills/sqltrace-review GET https://markdownregistry.com/api/v1/blob/72fb0ce8099ab0231deca66de838ecb9f568be9f05c5e4370ef2a622f2328c98
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.