Home
Do you run your dog food stats (before)?
  v1.0 Posted at 13/08/2015 10:30 PM by Ben Cull

Run the excellent DogFoodStats queries:

o   For TFS 2010 - from Grant Holliday - http://blogs.msdn.com/b/granth/archive/2009/10/23/tfs2010-sql-queries-for-tfs-statistics.aspx   .

o   For TFS 2012 – update from Erin Dormier -http://blogs.msdn.com/b/visualstudioalm/archive/2013/08/20/tfs-internal-usage-statistics-1st-half-cy-2013.aspx#comments 


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

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments:

    Note: Social Media login for Yotpo is not working in IE or Safari, please use Chrome. We are waiting for Yotpo to fix it.