Statistics Summary

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

1. Open Statistics Summary from Axial SQL Tools.
2. Run a query with SET STATISTICS IO ON;.
3. Optionally add SET STATISTICS TIME ON;.
4. 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