Do you run your dog food stats (before TFS 2015 migration)?

Run the excellent DogFoodStats queries:

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