sqltrace-reviewlisted

# 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) - A natural-language description of trace contents ("the trace shows 48,000 executions of a stored proc in 60 seconds, each reading 3,200 pages") **Duration units:** SQL Profiler `.trc` Duration column = **microseconds**. Extended Events `duration` = **microseconds**. CPU units differ by event class: for `SQL:BatchCompleted` (EventClass 12), CPU is in **milliseconds**; for `RPC:Completed` (Ev