sqlstats-reviewlisted

# SQL Server Statistics IO/Time Review Skill ## Purpose Parse raw `SET STATISTICS IO, TIME ON` output from SQL Server Management Studio and produce a structured report of I/O activity and timing per statement. Applies 27 checks across IO patterns (I1–I18) and time patterns (W1–W9) to surface performance concerns that the raw output obscures. This is the IO/time complement to `sqlplan-review`. Run it when you have STATISTICS output but no execution plan, or alongside the plan to cross-reference what actually happened at the I/O layer. ## Input Accept any of: - Raw SSMS console output pasted inline (everything after `SET STATISTICS IO, TIME ON`) - A plain-text `.txt` file path containing the console output - A description of what the output showed ("physical reads on Orders table, 140ms elapsed") The input may contain mixed content — IO lines, time lines, rows-affected messages, error messages, and unrelated output. Parse only the recognized patterns; preserve unrecognized lines as informational context. ## Supported Input Line Formats ### STATISTICS IO line ``` Table 'TableName'. Scan count X, logical reads Y, physical reads Z, read-ahead reads A, lob logical reads B, lob physical reads C, lob read-ahead reads D. ``` Optional additional fields (appear in Azure SQL or columnstore workloads): - `page server reads` — Azure SQL Hyperscale: reads from page server (remote storage) - `page server read-ahead reads` — Azure SQL Hyperscale prefetch - `lob page server reads`, `l