Posts
22
Comments
75
Trackbacks
0
SQL Server Statistics Parser

 

Working as a Data Engineer, one of my key role is to do Query and Server Optimizations, and one of the weird things that we will be seeing is this Nerdy Data

image 

Of course this does not automatically show up unless you turn this 2 ON

SET STATISTICS IO ON
SET STATISTICS TIME ON

 

Whole Query Sample

image

 

The data is pretty readable and understandable but still can be improved, Hopefully soon by Microsoft via SSMS(SQL Server Management Studio).

 

Luckily  Richie Rump (https://twitter.com/jorriss)  created a site - http://statisticsparser.com/ that let’s us paste our data and parse them into this,

image

Now if we want to compare(before/after) stats from queries that we are optimizing improvements should be more READABLE.

 

And if you are wondering if the site collects that Data including the table names?

NO, the site does not collect anything, and the author is kind enough to share his source code on GITHUB incase you want to setup your own under your webserver

https://github.com/Jorriss/StatisticsParser

posted on Friday, November 4, 2016 10:38 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Comment *  
Verification
Tag Cloud