Statistics Summary

Jump to bottom

Blake Becker edited this page Jun 3, 2026 · 2 revisions

Statistics Summary makes SET STATISTICS IO output much easier to read. Instead of scanning through raw message text, you get a quick summary that helps you compare query versions and spot which tables are doing the most work.

If SET STATISTICS TIME is also enabled, the window includes CPU time and elapsed time as part of the summary.

What it shows

Total reads for the execution
Reads per table
Scan count per table
Total CPU time and elapsed time when available
Source connection and database
The source query in an expandable section

How to use

Open Statistics Summary from Axial SQL Tools.
Run a query with SET STATISTICS IO ON;.
Optionally add SET STATISTICS TIME ON;.
Execute the query and review the summary.

Why it is useful

Makes SQL Server statistics output easier to compare
Helps identify which tables are responsible for the most reads
Gives a quick summary without manually adding values from repeated table entries