SQL Statistics Parser

About SQL Statistics Parser

What is the SQL Statistics Parser?

The SQL Statistics Parser turns noisy SQL Server SET STATISTICS IO/TIME ON output into a clean, readable summary. It aggregates reads and timing so you can quickly spot which statements and tables drive the most I/O.

How It Works

1. In SQL Server Management Studio (SSMS), run:

   SET STATISTICS IO ON;
   SET STATISTICS TIME ON;
   -- your query here

2. Copy the output messages and paste them into this tool.
3. Click Parse to see totals and breakdowns.

What You Get

1. Per-Table Totals across all statements (scan count, logical/physical/read-ahead, LOB I/O).
2. Per-Statement Totals with CPU and elapsed time when present.
3. Details by Statement showing each table’s contribution, sorted by logical reads.
4. Combine LOB option to fold LOB reads into main totals for simpler comparisons.
5. Export results to CSV or JSON for sharing or deeper analysis.

Tips

• Focus on logical reads to compare query plans; they are a good proxy for buffer cache work.
• Use SET STATISTICS TIME to include CPU and elapsed times for each statement.
• Filter or sort by the largest contributors to guide indexing or query rewrites.

Privacy

All parsing happens in your browser — no data is uploaded or stored.