Statistics Parser

Today I’d like to recommend a free community tool, StatisticsParser.com. Statistics Parser is web-based tool for interpreting the text output of the T-SQL SET STATISTICS IO and TIME settings. The tool was created and is maintained by Richie Rump (b | t), a successful speaker, blogger, and all-around SQL Server community contributor.

Richie-Rump

Quick SSMS demo

Enable the statistics output in your SSMS query window and then execute a batch.

SET STATISTICS IO, TIME ON

--Specially designed query which uses both time and IO
SELECT *
FROM AdventureWorks2012.Sales.SalesOrderDetail

SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.

(121317 row(s) affected)
Table ‘SalesOrderDetail’. Scan count 1, logical reads 1246, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:
CPU time = 78 ms, elapsed time = 983 ms.

Well, that is not very hard to read. I guess I was too lazy to create a complicated demo script. Thankfully, Richie is an enabler of my laziness. Open a web browser to StatisticsParser.com and we will let Richie help me out.

StatisticsParser.com

As you land on the homepage, check the Show Example Statistics IO Output check box. This will populate the empty text box with more complicated statistical data then I had shown above. That empty text box is where you would normally paste in the output from SSMS for parsing.

parser1

Once you have your statistics output in the text box, whether example statistics or your actual pasted statistics, click the blue Parse button in the bottom left. That completes the two step process. You now have easy to read roll-ups on a per query basis and totals for the entire batch.

parser2

Thank the #SQLFamily

Our #SQLFamily is generous, selfless, and down right AWESOME! On this Thanksgiving, I am thankful for every member of our great community who volunteer their time to share knowledge and build great tools to make our lives a bit easier.

Leave a Reply

%d bloggers like this: