VSTS Pioneer TFS2010 Dogfood Server: Statistics September 2009
(See this summary on the VSTS Pioneer dogfood server and all the other posts.)
September was a busy month for dogfooding TFS – all of the VSTS team were completely moved across and on 9/17 we upgraded to an almost final TFS2010 Beta 2 build. Here are the numbers from the end of September:
Version Control
- Files & Folders: 10,722,118
- Compressed File Sizes (MB): 263,350
- Uncompressed File Sizes (MB): 773,731
- Checkins: 23,369
- Pending Changes: 55,697
- Local Copies: 303,331,190
Work Item Tracking
It looks like I don’t have the work item tracking stats for September – I’ll have them next month.
Commands (last 2 weeks in September)
- Work Item opens: 113,128
- Work Item queries: 101,203
- Work Item updates: 23,653
- Checkins: 1,855
- Uploads: 6.622
- Shelves: 2,402
- Downloads: 216,452
- Gets: 30,201
Table sizes
One of the interesting metrics that I’m also tracking is how our tables and indexes are growing on the disks. Here’s the top 10 for this month:
| Table | Rows | Reserved (MB) | Data (MB) | Index (MB) | Unused (MB) |
| tbl_Content | 5,915,547 | 277,260 | 275,129 | 4 | 2,127 |
| tbl_LocalVersion | 303,331,190 | 81,562 | 44,789 | 36,574 | 199 |
| Attachments | 63,783 | 11,928 | 11,908 | 13 | 7 |
| tbl_Version | 12,129,564 | 3,418 | 1,031 | 2,369 | 17 |
| WorkItemLongTexts | 2,728,618 | 3,314 | 2,533 | 777 | 5 |
| tbl_VersionedItem | 15,754,176 | 2,983 | 1,598 | 1,382 | 3 |
| WorkItemsWere | 1,239,831 | 2,482 | 1,617 | 863 | 2 |
| tbl_PropertyValue | 33,293,914 | 1,320 | 523 | 793 | 4 |
| tbl_File | 5,717,981 | 722 | 442 | 266 | 14 |
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
