Posts
20
Comments
70
Trackbacks
0
November 2016 Entries
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 | Comments (0)
Tag Cloud