DevDiv TFS Database Sizes

DevDiv TFS Database Sizes | ASP NET Hosting

DevDiv TFS Database Sizes | ASP NET Hosting — Mon, 01 Jun 2009 00:13:42 GMT

PingBack from http://asp-net-hosting.simplynetdev.com/devdiv-tfs-database-sizes/

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

Константин Косинский — Mon, 01 Jun 2009 09:05:30 GMT

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

re: DevDiv TFS Database Sizes

BertrandH — Tue, 02 Jun 2009 18:40:51 GMT

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

re: DevDiv TFS Database Sizes

Martin Huige - Exxon MObil — Fri, 12 Jun 2009 21:05:51 GMT

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?

re: DevDiv TFS Database Sizes

Val — Sat, 13 Jun 2009 01:50:17 GMT

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

re: DevDiv TFS Database Sizes

bharry — Mon, 15 Jun 2009 15:00:29 GMT

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

re: DevDiv TFS Database Sizes

Val — Mon, 15 Jun 2009 20:13:47 GMT

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...