{"id":1467,"date":"2021-02-18T21:41:16","date_gmt":"2021-02-18T21:41:16","guid":{"rendered":"https:\/\/seehear.info\/?page_id=1467"},"modified":"2021-02-20T12:17:57","modified_gmt":"2021-02-20T12:17:57","slug":"io-statistics-parser","status":"publish","type":"page","link":"https:\/\/seehear.info\/?page_id=1467","title":{"rendered":"IO Statistics Parser"},"content":{"rendered":"\n<p style=\"font-size:14px\"><em>Our Editorial Team came across this and thought you may find it useful:<\/em><\/p>\n\n\n\n<p>&#8220;Sometimes reading SQL Server ouput from Statistics IO and Statistics Time can be a total drag. This page will help with that. Just paste in the output of Statistics IO and\/or Statistics Time and press Parse. Your output will be formatted and totaled. Enjoy.&#8221;<\/p>\n\n\n\n<p><a href=\"http:\/\/statisticsparser.com\/\">Statistics Parser<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>From the site About page:<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">&#8220;Statistics Parser<\/h1>\n\n\n\n<p>This site allows you to take the output of SQL Server&nbsp;<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms184361.aspx\">STATISTICS IO<\/a>&nbsp;then transforms and totals it into a more useful format. If you&#8217;re looking to save the results of STATISTICS IO you may want to look at&nbsp;<a href=\"http:\/\/vickyharp.com\/2012\/03\/using-excel-to-parse-set-statistics-io-output\/\">Vicky Harp&#8217;s excellent Excel based STATISTICS IO parser.<\/a>&nbsp;Excel is awesome. Excel is my boy. But sometimes I don&#8217;t want to open up a sixth instance of Excel. That&#8217;s where this site comes in. If you need to figure out what the heck STATISTICS IO or STATISTICS TIME is telling you quickly this site is here to help!<\/p>\n\n\n\n<p>This site is entirely written in JavaScript and HTML. So your data stays where it should&#8230;in your browser. Your data is never sent to a server. The site also uses the awesome Bootstrap CSS framework so a regular SQL hack like myself can create great looking sites.&nbsp;<a href=\"http:\/\/jquery.com\/\">JQuery<\/a>&nbsp;and the&nbsp;<a href=\"http:\/\/www.datatables.net\/\">DataTables<\/a>&nbsp;plug-in are also used to format the STATISTICS IO results. The source for this site is located on GitHub if you&#8217;re so inclined to take a peek at it (view source is also an option&#8230;I&#8217;m just sayin&#8217;).<\/p>\n\n\n\n<p>I hope you find this site useful. If you have any questions or comments feel free to hit me up over on my&nbsp;<a href=\"http:\/\/www.jorriss.net\/\">blog<\/a>&nbsp;or&nbsp;<a href=\"http:\/\/twitter.com\/jorriss\">twitter<\/a>. Enjoy.<\/p>\n\n\n\n<p>Richie<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Special Thanks<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Dave Nicolas (<a href=\"https:\/\/twitter.com\/dvee81\">twitter<\/a>): For the help with the DataTables and not killing me when you read my code.<\/li><li>Alvaro Mosquera Gayoso: For helping with the translation of Statistics IO output in Spanish.<\/li><li>Ranga Narasimhan: For suggesting that the site could use a clear button.<\/li><li>Uwe Ricken (<a href=\"http:\/\/db-berater.blogspot.com\/\">blog<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/twitter.com\/dbBerater\">twitter<\/a>): For finding JavaScript bugs and for suggesting the &#8220;Change page title&#8221; option.<\/li><li>Jeremiah Peschka (<a href=\"http:\/\/facility9.com\/\">blog<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/twitter.com\/peschkaj\">twitter<\/a>): For finding and reporting a table parsing bug.<\/li><li>JK Wood (<a href=\"http:\/\/sqlslacker.net\/\">blog<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/twitter.com\/sqlslacker\">twitter<\/a>): For finding and reporting a table parsing bug.<\/li><li>Brent Ozar (<a href=\"http:\/\/brentozar.com\/\">blog<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/twitter.com\/brento\">twitter<\/a>): For promoting StatisticsParser.com in blog posts, webinars, and conference presentaions across the globe. Also for suggesting that the Statistics IO could use a total table.&#8221;<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Our Editorial Team came across this and thought you may find it useful: &#8220;Sometimes reading SQL Server ouput from Statistics&hellip;<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-1467","page","type-page","status-publish","hentry"],"acf":[],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/seehear.info\/index.php?rest_route=\/wp\/v2\/pages\/1467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seehear.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/seehear.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/seehear.info\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/seehear.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1467"}],"version-history":[{"count":3,"href":"https:\/\/seehear.info\/index.php?rest_route=\/wp\/v2\/pages\/1467\/revisions"}],"predecessor-version":[{"id":1696,"href":"https:\/\/seehear.info\/index.php?rest_route=\/wp\/v2\/pages\/1467\/revisions\/1696"}],"wp:attachment":[{"href":"https:\/\/seehear.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}