{"id":9431,"date":"2007-04-18T09:17:21","date_gmt":"2007-04-18T09:17:21","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2007\/04\/18\/dogfood-io-analysis\/"},"modified":"2018-08-14T00:34:08","modified_gmt":"2018-08-14T00:34:08","slug":"dogfood-io-analysis","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/dogfood-io-analysis\/","title":{"rendered":"Dogfood I\/O Analysis"},"content":{"rendered":"<p>I&#8217;ve been falling so far behind on everything I&#8217;m supposed to do I just can&#8217;t stand it.&nbsp; Today is my day to try to catch up on blogging.&nbsp; I promised I&#8217;d follow up on the dogfood I\/O analysis from the Orcas upgrade.&nbsp; Well, I got the results a week or two ago and I just can&#8217;t find anything particularly useful.&nbsp; The problem is that the data we have from the various samples we&#8217;ve taken over the last year are all different enough that it&#8217;s hard to compare apples to apples.&nbsp; We haven&#8217;t used the same methodology.&nbsp; We&#8217;ve reconfigured the drives and repartitioned tables, etc.&nbsp; To a first approximation I&#8217;ve given up trying to extract useful before and after I\/O data.&nbsp; Instead we are going to run another trace to see which sprocs now have the highest I\/O demand and focus on just making those better and worry less about quantifying the improvement.<\/p>\n<p>In case you care, here&#8217;s some data we got from the last set of I\/O analysis &#8211; at least you can see in the absolute what kind of I\/O load we are seeing.&nbsp; As I&#8217;ve said before, Version Control is really where all of our I\/O load is, so that&#8217;s where we focused.&nbsp; Also, you&#8217;ll note we&#8217;ve broken the Version Control tables across multiple volumes due to the high load.&nbsp; Here&#8217;s how the tables map to drives:<\/p>\n<ul>\n<li>G:&nbsp;tbl_LocalVersion<\/li>\n<li>J:&nbsp;all the remaining tables in version control.<\/li>\n<li>K:&nbsp;tbl_Version<\/li>\n<\/ul>\n<p><img decoding=\"async\" height=\"351\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/clip_image002.gif\" width=\"1203\"><\/p>\n<p><img decoding=\"async\" height=\"351\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/clip_image002%5B1%5D.gif\" width=\"1223\"><\/p>\n<p><img decoding=\"async\" height=\"351\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/clip_image002%5B2%5D.gif\" width=\"1223\"><\/p>\n<p>If you can extract useful info from this, please let me know \ud83d\ude42&nbsp; Once we get the break down by sproc, I&#8217;ll share that.<\/p>\n<p>Thanks,<\/p>\n<p>Brian<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been falling so far behind on everything I&#8217;m supposed to do I just can&#8217;t stand it.&nbsp; Today is my day to try to catch up on blogging.&nbsp; I promised I&#8217;d follow up on the dogfood I\/O analysis from the Orcas upgrade.&nbsp; Well, I got the results a week or two ago and I just [&hellip;]<\/p>\n","protected":false},"author":244,"featured_media":14617,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[5,3],"class_list":["post-9431","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs","tag-tfs-dogfood-statistics"],"acf":[],"blog_post_summary":"<p>I&#8217;ve been falling so far behind on everything I&#8217;m supposed to do I just can&#8217;t stand it.&nbsp; Today is my day to try to catch up on blogging.&nbsp; I promised I&#8217;d follow up on the dogfood I\/O analysis from the Orcas upgrade.&nbsp; Well, I got the results a week or two ago and I just [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/9431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/users\/244"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/comments?post=9431"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/9431\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/media\/14617"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/media?parent=9431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=9431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=9431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}