Welcome to MSDN Blogs Sign in | Join | Help

DevDiv TFS Database Sizes

Someone asked me the other day how big to expect the relative sizes of TFS databases to be.  At the time all I had time to say was “Over time TfsVersionControl will dwarf everything else”.  This weekend, I finally had a few minutes to sit down and do some analysis.  As with all such things, your mileage will vary.  DevDiv is a VERY heavy version control user and this may be a bit disproportionate from what you’ll see but as a system grows, I expect it will start to look more and more like this.

 

Here’s a pie chart that shows you relative sizes:

image

And here’s the actual numbers:

image

It’s worth looking at how TfsVersionControl breaks down.  Note this won’t match your schema exactly because it is a hybrid TFS 2008/TFS 2010 schema but what I show you will be close.

image

image

Brian

Published Sunday, May 31, 2009 4:18 PM by bharry

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# DevDiv TFS Database Sizes | ASP NET Hosting

Sunday, May 31, 2009 5:13 PM by DevDiv TFS Database Sizes | ASP NET Hosting

# Dogfooding: Размеры баз данных TFS у Microsoft DevDiv

Ранее я писал о базе данных SQL Server 2008 размером в 300 Тб, но она используется для хранения и анализа

Monday, June 01, 2009 2:05 AM by Константин Косинский

# re: DevDiv TFS Database Sizes

Hi,

Just as a note, the rss and atom feeds do not seem to be updated since may 29th.

Same for latest post for Aaron Halberg.

Is there a problem with your blogs site publishing?

Bertrand

Tuesday, June 02, 2009 11:40 AM by BertrandH

# re: DevDiv TFS Database Sizes

We at ExxonMobil are very interested in your statistics. Are you saying your instance is 15.2 terabytes? We are very concerned about capacity issues here pertaining to the size of our version control database and the number of projects we can have on our TFS 2008 SP1 instance. Can you confirm your numbers. This will lay to rest some of the concerns we have about the future capacity of our instance. Further to this, how many projects do you have on your server?

Friday, June 12, 2009 2:05 PM by Martin Huige - Exxon MObil

# re: DevDiv TFS Database Sizes

Ditto -- are those really GB? and ~1.6 Billion rows in tbl_MergeHistory?

Friday, June 12, 2009 6:50 PM by Val

# re: DevDiv TFS Database Sizes

Martin/Val, you should be careful about drawing too many conclusions from this data about how your server will grow.

The DevDiv TFS server is (I believe) the largest in the world.  A full branch has ~7 million files in it (most of them test code) and there are over 100 branches (not all of them full).  I don't expect that very many organizations will do this.

The best way to project growth of your own server will be to track some of these statistics over time and see how they are changing.

I'll do another post in the near future on a more "typical" server from our IT organization.

Yes, 1.6 billion rows in tbl_MergeHistory and the numbers are really GB (meaning many of them are a few terrabytes).

Brian

Monday, June 15, 2009 8:00 AM by bharry

# re: DevDiv TFS Database Sizes

Brian,

Thanks for confirming. We don't expect our repositories to get quite this big any time soon ;) I guess this puts most scaling questions to rest...

Monday, June 15, 2009 1:13 PM by Val

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker