{"id":6491,"date":"2009-07-13T11:17:46","date_gmt":"2009-07-13T11:17:46","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2009\/07\/13\/july-09-devdiv-dogfood-statistics\/"},"modified":"2018-08-14T00:21:35","modified_gmt":"2018-08-14T00:21:35","slug":"july-09-devdiv-dogfood-statistics","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/july-09-devdiv-dogfood-statistics\/","title":{"rendered":"July ‘09 DevDiv Dogfood Statistics"},"content":{"rendered":"

It\u2019s been about 6 months since I last posted detailed statistics on the DevDiv TFS dogfood server.  Overall it\u2019s been a good 6 months.  Early this year we got the bulk of our TFS 2010 branching\/merging\/scaling changes deployed to the server and they\u2019ve made a a big difference in the scalability challenges we were having last fall.  The server\u2019s running pretty well these days.<\/p>\n

Later this month we\u2019ll be setting up a second DevDiv dogfood server that will mirror chunks of the \u201cmain\u201d server and will be used by the Visual Studio Team System team.  This new separate server will exist because we need a way that we can use pretty recent builds without disrupting the work environment for the broader division with frequent updates. I\u2019ll write some more about this in the next few weeks as the rollout progresses.<\/p>\n

Here are some things that stand out to me when I look at the numbers:<\/p>\n

1) Checkins are way up.  My guess is that\u2019s due to the fact that we are in an intense bug fixing period right now and we are probably seeing a whole lot of very small checkins.<\/p>\n

2) File downloads are way down.  Every since we put in the 3 node proxy to handle the download volume, the download numbers just haven\u2019t been relevant any more.  I don\u2019t have any good way to collect statistics from the proxies (they aren\u2019t instrumented as well as the main server is).  I think this may be the last report that I include download numbers in because they just aren\u2019t very relevant.<\/p>\n

3) Files and Work item versions continue their astonishingly steady climb.<\/p>\n

4) Workspaces are way up.  In the fall and early this year we were aggressively deleting old unused workspaces in preparation for a series of server upgrades we were doing.  We\u2019ve pretty much let them go the last several months so they\u2019ve been piling up.<\/p>\n

5) I\u2019ve stopped counting files & folders separately.  For one thing the number has gotten huge.  Secondly the TFS 2010 schema is less optimized to counting the difference.  It basically involves a > 600 million row table scan on our data base and that\u2019s way too long.<\/p>\n

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

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

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

 <\/p>\n

Users<\/p>\n