Welcome to MSDN Blogs Sign in | Join | Help

April DevDiv Dogfood Statistics

It’s now been over a month since the DevDiv dogfood server upgrade to Orcas bits.  We’ve continued to poke and prod at the server and make patches as we identify issues.  The rate has slowed down from that first hectic week of several patches a day to about 1 a week or so now.  Overall performance is much better and reliability has stayed very good (7 day availability is at 100% right now).  We’ve identified a bunch of great bugs for which the fixes are going into Beta 1.  Last weekend, we are did the “final” upgrade of the Office TFS server with the Rosario Internal Release bits for Office’s “go live” on Monday.  Just seems like the excitement never stops.

We passed a couple of milestones in the past month:

  • We passed the 200,000 work item point.  It’s not huge by historical standards but it’s pretty big and is a cool milestone.
  • The local version table passed the 500,000,000 row mark.  Yes, half a billion rows!  By any measure, that’s a lot of data :)

 

Current Statistics

Users

  • Recent users: 1,047 (down 85)
  • Users with assigned work items: 2,743 (up 172)
  • Version control users: 2,249 (up 98)

Work Items

  • Work Items: 209,336 (up 16,151)
  • Areas & Iterations: 7,386 (up 119)
  • Work item versions: 1,722,408 (up 141,465)
  • Attached files: 73,115 (up 6,330)
  • Queries: 16,465 (up 785)

Version control

  • Files/ Folders: 77,658,652/16,387,979 (up 5,100,133/up 1,788,298)
  • Total compressed file size: 780.1 GB (up 125.4 GB)
  • Checkins: 204,556 (up 19,673)
  • Shelvesets: 9,356 (up 978)
  • Merge history: 179,945,762 (up 10,961,392)
  • Pending changes: 2,625,368 (up 1,581,548)
  • Workspaces: 4,784 (up 435)
  • Local copies: 507,675,684 (up 66,868,508)

Commands (last 7 days)

  • Work Item queries: 531,108 (up 308,847)
  • Work Item updates: 216,277 (up 183,991)
  • Work Item opens: 273,722 (up 200,940)
  • Gets: 171,988 (down 322,075)
  • Downloads: 18,142,774 (down 5,166,454)
  • Checkins: 10,547 (up 7,032)
  • Uploads: 262,375 (down 56,531)
  • Shelves: 1,080 (down 42)

You'll notice that gets are way down this month.  That's because we finally fixed a tool someone wrote that was spamming the server with Get requests once every few seconds 24 hours a day, 7 days a week.  That brings me to an interesting observation about TFS.  It's kind of amazing to me how many internal tools people have written against TFS.  I think it comes from the power of having a completely open and public API.  Here's a list of the tools that I see have run against the dogfood server in the past week.  I've removed from the list everything that shipped in the box with TFS - so these are just tools that someone else has written.  Some of them are listed a couple of times due to different versions.  There's about 80 in the list sorted in decending order of load they put on the server.

Thanks,

Brian

Published Wednesday, April 18, 2007 9:00 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: April DevDiv Dogfood Statistics

Wednesday, April 18, 2007 9:32 AM by Peter Ritchie

Very cool.  Doesn't seem to be a big change with the Orcas bits (except for the tool fix and file download count).

I'd be interested in knowing why there was ~15000 extra check-ins around May last year, then over 1000 less workspaces in June.  It appears that a project ended; but I would expect those workspaces would re-appear on another project fairly quickly (it didn't seem to get back to the same level for four months).

# re: April DevDiv Dogfood Statistics

Wednesday, April 18, 2007 12:23 PM by Vickie

Good stats.

Where should I look in TFS if I'd like to create these metrics for my team?

# re: April DevDiv Dogfood Statistics

Wednesday, April 18, 2007 2:34 PM by bharry

Well, I've got a tool to do it coming if I can ever get it done.  See this post:  http://blogs.msdn.com/bharry/archive/2007/01/22/tfsservermanager-powertool.aspx

While you wait, this post lists many of the queries I run to gather this data: http://blogs.msdn.com/bharry/archive/2006/06/12/628583.aspx

Brian

# re: April DevDiv Dogfood Statistics

Wednesday, April 18, 2007 2:40 PM by bharry

Sorry, missed one.  I don't know the reason for the checkin spike last May.  I suspect it had something to do with bringing much of the division onto TFS.  Obviously, I could do some archeology and find out.  If I get some time, I will.

The drop in workspaces in June was when I deleted all workspaces that hadn't been used in a long time (6 months, I think).  Since then, I haven't deleted very many more because I'm trying to see how long it takes to get the LocalVersion table over a billion rows (and how well the system will perform).  However, today, probably 25-30% of the workspaces aren't actually used any more.  People just forget to delete them.

Brian

# VSTS Links - 04/19/2007

Thursday, April 19, 2007 10:57 AM by Team System News

Brian Harry had a busy day of posting with April DevDiv Dogfood Statistics, Dogfood I/O Analysis, Managing...

# re: April DevDiv Dogfood Statistics

Thursday, April 19, 2007 5:33 PM by Vickie

I hope the tfsservermanager tool becomes available some time soon...in the interim, I'll live with the queries.

Thanks!

# How quaint: 1,000,000 files and 10,000 changesets

Thursday, April 19, 2007 9:32 PM by Buck Hodges

I wrote posts when we hit 1,000,000 files (Nov. 18, 2005) and 10,000 changesets (Sept. 26, 2005) on the

# Over 500 Million served

Saturday, April 21, 2007 10:58 AM by Jeff Beehler's Blog

I'm old enough to remember when McDonald's would display the number (in millions and billions) of hamburgers

# Teamprise announces a Java SDK for Team Foundation Server

Wednesday, May 09, 2007 6:52 AM by bharry's WebLog

Yesterday Teamprise announced the availability of a Java SDK for building TFS based applications. You

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker