{"id":6501,"date":"2009-07-13T08:38:17","date_gmt":"2009-07-13T08:38:17","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2009\/07\/13\/tfs-database-sizes-for-a-somewhat-more-normal-team\/"},"modified":"2018-08-14T00:21:35","modified_gmt":"2018-08-14T00:21:35","slug":"tfs-database-sizes-for-a-somewhat-more-normal-team","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/tfs-database-sizes-for-a-somewhat-more-normal-team\/","title":{"rendered":"TFS Database sizes for a somewhat more “normal” team"},"content":{"rendered":"

I talk a lot about the DevDiv dogfood server.  The numbers are always astronomical and people\u2019s heads spin when they see them and most people wonder what relevance it has to their life :)  I publish the DevDiv stuff for a variety of reasons.  I do it to show how scalable TFS is and that it is ready to handle almost anything you throw at it.  I also do it because I\u2019m closest to that server \u2013 I use it all the time so it\u2019s somewhat personal.<\/p>\n

I think I\u2019m going to start publishing information about other servers occasionally so that you can see what things looks like for a range of different teams\/usage scenarios.  Today I\u2019m going to write about a TFS server used by the AdCenter team.  It\u2019s still a pretty big team with 1,384 users in the past 2 weeks but their development methodology and legacy are quite different from DevDiv.<\/p>\n

The server is just over 3 years old \u2013 the first checkin was on 6\/7\/2006.  So you can think of these numbers as being relevant to about a 1,000 person team over 3 years.<\/p>\n

The first difference that I notice with the AdCenter team is that they create a lot of smaller Team Projects compared to DevDiv.  We have just a handful of Team Projects \u2013 maybe 20.  They have over 300.<\/p>\n

\"clip_image002\"<\/a><\/p>\n

 <\/p>\n

The relative sizes of databases still resembles DevDiv with Version Control being the lion\u2019s share and most other things nearly irrelevant.  Looking at this, I\u2019d say they do a lot of builds.<\/p>\n

\"clip_image001\"<\/a><\/p>\n

 <\/p>\n

Here\u2019s the top database sizes.  As you can see, it all adds up to about 350GB.  That\u2019s a far cry from the DevDiv 15 TB.  It\u2019s over 40X smaller even though the team size is only about 3X smaller.  Why is that?  Well, I\u2019ve said that VS is a bit of a weird org in this respect for a long time.  For one thing, the code base goes back more than 20 years.  For another, we use a VERY heavily branched development methodology that really blows up the version control database.  It\u2019s also a very connected code base resulting in the average developer needing hundreds of thousands of files in each workspace in order to build\/debug their component.<\/p>\n

\"clip_image001[5]\"<\/a><\/p>\n

Here\u2019s the breakdown of the version control database.  As always, tbl_LocalVersion is a big chunk.  tbl_LabelEntry looks very large so they must have a practice of labeling every build and keeping those labels around.  The rest are all pretty small.<\/p>\n<\/p>\n

\"clip_image001[7]\"<\/a><\/p>\n

And here\u2019s the numerical breakdown\u2026<\/p>\n

\"clip_image001[9]\"<\/a><\/p>\n

 <\/p>\n

As you can see, not all TFS databases (even for large teams) need be mammoth.  Development process plays a huge role in the strain you place on your development server.  Sometime in the next month or two, I\u2019ll find an even smaller server and one that is shared by many teams and you can see what those look like.<\/p>\n

Brian<\/p>\n","protected":false},"excerpt":{"rendered":"

I talk a lot about the DevDiv dogfood server.  The numbers are always astronomical and people\u2019s heads spin when they see them and most people wonder what relevance it has to their life :)  I publish the DevDiv stuff for a variety of reasons.  I do it to show how scalable TFS is and that […]<\/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],"class_list":["post-6501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs"],"acf":[],"blog_post_summary":"

I talk a lot about the DevDiv dogfood server.  The numbers are always astronomical and people\u2019s heads spin when they see them and most people wonder what relevance it has to their life :)  I publish the DevDiv stuff for a variety of reasons.  I do it to show how scalable TFS is and that […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/6501","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=6501"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/6501\/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=6501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=6501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=6501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}