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.
Quick SSMS demo
Enable the statistics output in your SSMS query window and then execute a batch.
[sql]SET STATISTICS IO, TIME ON
–Specially designed query which uses both time and IO
SELECT *
FROM AdventureWorks2012.Sales.SalesOrderDetail[/sql]
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.
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.
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.
