MrDave's (David Yack) Blog!

Anyone ever ask you why if TFS seems slower today than last week?  We get that once in a while - usually when backups are running! 

Apparently I'm not the only one that has been curios a good way to track down what's happening.  Grant Holiday one of the Team System MVP's did a great blog post on this here.

In his post he gives you the query to run against the TfsActivityLogging database that stores what commands etc have been performed and their associated timings.  He also helps you build a cool Excel heat map to quickly see where your hot spots are.

I think this would be a great weekly report for TFS to send to whoever is responsible for running the server.