WHAT'S IN THIS CHAPTER?
Understanding factors that affect Team Foundation Server health
Monitoring SQL Server health
Learning useful queries for investigating SQL Server performance
Learning about data sources available for monitoring Team Foundation Server
Using valuable tools and reports
The health of a Team Foundation Server can be broken down into three components:
SQL Server health
Team Foundation Server health
The health and performance of Team Foundation Server is largely dependent upon the health and performance of the underlying components. For example, if the storage subsystem is not performing well, then SQL Server performance will likely suffer and, in turn, affect the performance of Team Foundation Server commands.
This chapter provides an overview of how you can monitor the health and performance of Team Foundation Server.
While Team Foundation Server was being developed, the entire Developer Division at Microsoft started using the server as its primary source control and bug tracking system. This onboarding process continued through the 2008 release, and the overall size and usage of the server increased. As more teams were moved on to the server, performance issues with the application were identified and fixed.
Because of this aggressive internal usage over an extended time period, the 2010 release is highly tuned based upon real-world usage, rather than synthetic load tests. This level of tuning means that, ...