Do you run your dog food stats (before)?
Run the excellent DogFoodStats queries:
- For TFS 2010 - from Grant Holliday - TFS2010: SQL Queries for TFS Statistics .
- For TFS 2012 – update from Erin Dormier -TFS Internal Usage Statistics – 1st Half CY 2013
While the above scripts are intended for older versions of TFS, many of the SELECT statements also work with TFS 2013 Update 4.
The above scripts give you some great information about the details of our collections you can use for comparison afterwards.
Make sure you record these statistics so you can compare them after the upgrade.
Recent Users: 33
Users with Assigned Work Items: 145
**Warning: **Null value is eliminated by an aggregate or other SET operation.
Version Control Users: 244
Total Work Items: 20608
Areas and Iterations: 1838
Work Item Versions: 93298
Work Item Attachments: 11331
Work Item Queries: 12768
Compressed File Sizes: 18042
Uncompressed File Sizes: 36315
Merge History: 846922
Pending Changes: 906
Local Copies: 4197458
Command Execution Count
Figure: Example result of DogFoodStats on our TFS 2010 instance