Welcome to MSDN Blogs Sign in | Join | Help

January DevDiv TFS Dogfood Statistics

I skipped the December dogfood update because the activity numbers were so skewed at the end of the month by people’s vacations.  There’s nothing that particularly stands out about the dogfood server over the last month.  It continues to grow.  Availability has been good.  Performance continues to improve.  Perhaps the most interesting thing is that at one point in December we exceeded 1,000 active users for the first time.

I've been preparing a presentation this week to update Soma and Craig on what we are doing in TFS and as part of that we pulled together some updated data on overall Microsoft TFS adoption that I thought I'd share.

  • We currently have 10 production TFS servers with 5 more in the process of getting installed
  • We have 403 projects, 177 teams and 8,020 users
  • Adoption is growing at a rate of about 500 users per month

We've still got a long way to go before we have all of Microsoft is using TFS but we're making good progress and I'm quite happy about it.

 

Right now we are preparing to install (for the first time) and Orcas build on our DevDiv production server.  The goal is to do it in February.  I'll let you know how that goes in a month or so.  Also, I've talked to you in the past about some of the great version control performance improvements we've made in Orcas.  We've just wrapped up work on our Orcas work item tracking performance improvements so in the next few days I'll post some info about those results.

 

Here's the trends and stats for the month...

Users

  • Recent users: 980 (up 36)
  • Users with assigned work items: 2,576 (up 118)
  • Version control users: 1,875 (up 116)

Work Items

  • Work Items: 158,659 (up 15,966)
  • Areas & Iterations: 7,074 (up 137)
  • Work item versions: 1,282,913 (up 115,667)
  • Attached files: 53,521 (up 7,053)
  • Queries: 13,548 (up 871)

Version control

  • Files/Folders: 74,101,113/15,413,627 (up 6,435,965/1,556,063)
  • LocalCopies: 323,573,131 (up 44,301,818)
  • Total compressed file size: 427.803G (up 64.6G)
  • Workspaces: 3,721 (up 459)
  • Shelvesets: 6,976 (up 973)
  • Checkins: 153,353 (up 11,614)
  • Pending changes: 916,441 (down 77,474)

Commands (last 7 days)

  • Work Item queries: 149,938 (down 1,694)
  • Work Item updates: 24,045 (up 2,944)
  • Work Item opens: 71,985 (down 55,240)
  • Gets: 60,629 (down 33,092)
  • Downloads: 21,175,666 (up 5,453,884)
  • Checkins: 2,618 (up 16)
  • Uploads: 142,918 (up 11,941)
  • Shelves: 929 (up 90)

Brian

Published Thursday, January 11, 2007 8:19 AM 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

# re: January DevDiv TFS Dogfood Statistics

Thursday, January 11, 2007 12:23 PM by keith_hill

Is the Pending changes listed here (916, 441) really the number of outstanding pending changes?  Even with 1875 users, that's an average of 488 pending changes per user.  That seems like a lot.  Or is this the current changeset number?  At one time I thought you listed the changeset numbers.

# re: January DevDiv TFS Dogfood Statistics

Thursday, January 11, 2007 12:41 PM by bharry

Believe it or not, this is actually the number of files checked out.  Yes, it's hard to believe and when we first started seeing numbers in the hundreds of thousands I was stunned.

I've actually never gone and done a thorough investigation but I stronly suspect it is that there are a hand full of people who are doing merges of branches at any given time.  It's not unusual for a single merge of one of our product branches (of which there are 50 or so) to have 100,000 to 200,000 changes.  It wouldn't take many merges to be in play to add up to a million pending changes.  Some day I may actually dig further to see if there is more to it than that.

Brian

# re: January DevDiv TFS Dogfood Statistics

Friday, January 12, 2007 2:40 PM by kevin mallory

what % of the total devdiv projects are actually hosted at this point?

# re: January DevDiv TFS Dogfood Statistics

Sunday, January 14, 2007 10:26 AM by bharry

We don't measure it as "projects" per se because we have projects at many different scales and adoption is happening by team and not by project.  Right now we have about 40-50% of DevDiv using TFS for their daily work.  I'm hoping that by summer we can get that up closer to 70%.  We'll see though.

# re: January DevDiv TFS Dogfood Statistics

Thursday, January 18, 2007 9:36 AM by mcdonaldn@hotmail.com

Brian,

When discussing our proposed TFS environment with the DBAs they had some questions about how you're dealing with the database size in your TFS instances.  Apparently the size we're looking at for one of our TFS instances is a terabyte (space for all 11 databases that make up TFS).  Do you know what the database size is for your "TfsVersionControl" database (or if you have time, all 11 database sizes would be nice)?  Is the size of "TfsVersionControl" what you post under "Total compressed file size: 427.803G"?

Any misunderstanding of our DBAs questions are my fault so excuse any ignorance.

1)  Backups/Restores - With these large databases, do you have any issues with backups and/or restores?  How often do you run backups?  How long do they take typically?

2)  Integrity Checks - Do you run periodic "integrity checks" on the database and if so, how long do they take?

3)  Index Regeneration - Do you run periodic "index regeneration" on the database and if so, how long does it take?

Again excuse any ignorance on terminology and misunderstanding on my behalf.

Mac Noland

# re: January DevDiv TFS Dogfood Statistics

Saturday, January 20, 2007 10:52 AM by bharry

Sorry, I got this answered in email.  Here were the answers for all to see:

0)Database size

·         Version control: 928G

·         Workitem tracking: 121G

·         Warehouse: 17G

The rest is noise.

1)Backups

Full Databases backups (using LiteSpeed) – Every night

Transactional Logs backups (using LiteSpeed) – Every 15 minutes

For our biggest instance (DevDiv, total size a little bit over 1TB) – total full backup time for all databases is around 10-12 hours.

2) Integrity checks

dbcc checkdb for all databases – every weekend (total time 3-5 hours for all databases)

3) Index defragmentation

every weekend (total time 2-3 hours for all databases)

Full index rebuilds have gotten very long and can't be done online so we are looking at partitioning some of our largest tables to make that infrequent maintainence operation less disruptive.

Brian & Dmitriy (from our operations team)

# Internal TFS server database maintenance

Saturday, January 20, 2007 11:34 AM by Buck Hodges

Brian posted these answers in a comment to a question on his January dogfood statistics post . These

# New TFS tool - TFSProxy

Thursday, February 01, 2007 3:55 PM by BUGBUG: poor title

I love it when participating in the community pays off. Barely a week later, we had a neat little applet

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker