Do you run your dog food stats (before TFS 2015 migration)?
Last updated by Tiago Araújo [SSW] about 3 years ago.See historyRun 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
Files: 694604
Compressed File Sizes: 18042
Uncompressed File Sizes: 36315
Checkins: 53297
Shelvesets: 381
Merge History: 846922
Pending Changes: 906
Workspaces: 259
Local Copies: 4197458
Command Execution Count
Checkin 27
Get 578
Shelve 96
Upload 162
VCDownloadHandler 1403
GetWorkItem 558
QueryWorkitems 830
Update 272
Figure: Example result of DogFoodStats on our TFS 2010 instance