{"id":6561,"date":"2009-05-31T16:18:35","date_gmt":"2009-05-31T16:18:35","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2009\/05\/31\/devdiv-tfs-database-sizes\/"},"modified":"2018-08-14T00:21:37","modified_gmt":"2018-08-14T00:21:37","slug":"devdiv-tfs-database-sizes","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/devdiv-tfs-database-sizes\/","title":{"rendered":"DevDiv TFS Database Sizes"},"content":{"rendered":"<p>Someone asked me the other day how big to expect the relative sizes of TFS databases to be.&#160; At the time all I had time to say was \u201cOver time TfsVersionControl will dwarf everything else\u201d.&#160; This weekend, I finally had a few minutes to sit down and do some analysis.&#160; As with all such things, your mileage will vary.&#160; DevDiv is a VERY heavy version control user and this may be a bit disproportionate from what you\u2019ll see but as a system grows, I expect it will start to look more and more like this.<\/p>\n<p>&#160;<\/p>\n<p>Here\u2019s a pie chart that shows you relative sizes:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_12.png\"><img decoding=\"async\" title=\"image\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"484\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb_5.png\" width=\"640\" border=\"0\" \/><\/a> <\/p>\n<p>And here\u2019s the actual numbers:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_14.png\"><img decoding=\"async\" title=\"image\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"275\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb_6.png\" width=\"424\" border=\"0\" \/><\/a> <\/p>\n<\/p>\n<p>It\u2019s worth looking at how TfsVersionControl breaks down.&#160; Note this won\u2019t match your schema exactly because it is a hybrid TFS 2008\/TFS 2010 schema but what I show you will be close.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_8.png\"><img decoding=\"async\" title=\"image\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"478\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb_3.png\" width=\"644\" border=\"0\" \/><\/a> <\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_10.png\"><img decoding=\"async\" title=\"image\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"192\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb_4.png\" width=\"454\" border=\"0\" \/><\/a> <\/p>\n<\/p>\n<p>Brian<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Someone asked me the other day how big to expect the relative sizes of TFS databases to be.&#160; At the time all I had time to say was \u201cOver time TfsVersionControl will dwarf everything else\u201d.&#160; This weekend, I finally had a few minutes to sit down and do some analysis.&#160; As with all such things, [&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-6561","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs","tag-tfs-dogfood-statistics"],"acf":[],"blog_post_summary":"<p>Someone asked me the other day how big to expect the relative sizes of TFS databases to be.&#160; At the time all I had time to say was \u201cOver time TfsVersionControl will dwarf everything else\u201d.&#160; This weekend, I finally had a few minutes to sit down and do some analysis.&#160; As with all such things, [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/6561","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=6561"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/6561\/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=6561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=6561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=6561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}