{"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>\u201cSometimes 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.\u201d<\/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\">\u201cStatistics Parser<\/h1>\n\n\n\n<p>This site allows you to take the output of SQL Server\u00a0<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms184361.aspx\">STATISTICS IO<\/a>\u00a0then transforms and totals it into a more useful format. If you\u2019re looking to save the results of STATISTICS IO you may want to look at\u00a0<a href=\"http:\/\/vickyharp.com\/2012\/03\/using-excel-to-parse-set-statistics-io-output\/\">Vicky Harp\u2019s excellent Excel based STATISTICS IO parser.<\/a>\u00a0Excel is awesome. Excel is my boy. But sometimes I don\u2019t want to open up a sixth instance of Excel. That\u2019s 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\u2026in 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.\u00a0<a href=\"http:\/\/jquery.com\/\">JQuery<\/a>\u00a0and the\u00a0<a href=\"http:\/\/www.datatables.net\/\">DataTables<\/a>\u00a0plug-in are also used to format the STATISTICS IO results. The source for this site is located on GitHub if you\u2019re so inclined to take a peek at it (view source is also an option\u2026I\u2019m just sayin\u2019).<\/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\u00a0<a href=\"http:\/\/www.jorriss.net\/\">blog<\/a>\u00a0or\u00a0<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>\u00a0|\u00a0<a href=\"https:\/\/twitter.com\/dbBerater\">twitter<\/a>): For finding JavaScript bugs and for suggesting the \u201cChange page title\u201d option.<\/li><li>Jeremiah Peschka (<a href=\"http:\/\/facility9.com\/\">blog<\/a>\u00a0|\u00a0<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>\u00a0|\u00a0<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>\u00a0|\u00a0<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.\u201d<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Our Editorial Team came across this and thought you may find it useful: \u201cSometimes 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}]}}