Service Engineer, Microsoft Visual Studio Online - Team Foundation Server
Update 6/23/2009: Due to popular demand, Jim from the Developer Support team at Microsoft has re-created the three reports that required SQL2008 Reporting Services. See the support team blog for more details.
Update 7/13/2010: These reports also work with TFS2010. When you setup the data source, just specify the name of a collection DB instead of TfsActivityLogging.
I’m on the team that runs the busiest Team Foundation Server at Microsoft. The Developer Division instance has over 3,500 active users and processes over 10,000,000 source control and work item tracking requests per day (not including the requests that our 5 proxy servers handle).
We have a responsibility to ensure that the server is performing as expected and to identify any efficiencies that can be made in the server or the tools. To do this, we have created a number of reports that we use ourselves and make available to our own users.
We’re now making these reports available to you to install on your own server and monitor your TFS server’s performance. The plan is to eventually roll these into a power tool release or a subsequent release of VSTS but I’ll let you know more about that when it happens.
The report pack consists of a ZIP file with a number of Report Definition (*.rdl) files. These files are designed to be deployed onto your existing TFS reporting server, e.g. http://your-tfsserver/Reports/
Here’s an overview of what the reports look like and what questions you can answer with them.
This report visualizes the load, in this case reflected by total execution time, on the server from two axis: users and commands.
Use this report when you want to know:
Source Control is undoubtedly the application that consumes the most resources on an Application Lifecycle Management (ALM) Server. Across the day, a series of requests get queued to be processed as transactions are committed to the database. This report provides a view into that queue.
Lots of red means that you have some long running operations and you may have some problems.
In the past, I’ve blogged a query to get this information – How many user’s are not using a TFS Proxy server? Internally, we have setup a scheduled subscription that emails this report twice a week.
IT departments strive to provide the best level of service to their users. Hardware requirements planning and setting up proxies are activities that ensure optimal performance for their internal teams when interacting with team Foundation Server. This report allows administrators a view into which users are not complying with internal guidelines and hence decreasing overall server performance.
This report serves as a summary of the average response time for two of the Team Foundation Server subsystems: Work Item Tracking and Version Control
This report provides more data granularity about the performance of the server. We start with a view into the server average response time, now looking at the entire picture instead of broken down by subsystem. We then follow with charts relating information about version control downloads and average response time distributions for the same time period.
I hope that you find these reports useful. Please send any questions or feedback as comments to this post, or contact me via email.
Announcing TFS Performance Report Pack Grant Holliday upload TFS Performance Reports that Microsoft use
I guess SRS 2008 is required. An error occurred when uploading a report in SQL Server 2005
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)"
Charles Sterling on New Visual Studio Team System Web Site:  http://www.tfsexamples.com Brian Harry
I get this error when using any of the two performance trends reports
An error occurred during client rendering.
An error has occurred during report processing.
Cannot create a connection to data source 'PrivateDataSource'.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Th error with 'PrivateDataSource' can be easily resolved by switching the datasource from the report server interface itself. Onc eyou see the error select the properties link and then go to the DataSource section and then you can select the previously created Shared Data Source. With this change I was able to get 3 reports working. However for the other reports I need 2005 format rdl. Is there anyway to convert the 2008 format to 2005?
The reports look good.
Having similar issues as folks above. We're running 2005 and only some of the reports can be uploaded. Those that are not uploading are because of the 2008 issue reported above. For those that I'm able to upload and run, I'm getting the error "Query execution failed for data set 'PerfData'."
Having the same problems as above. the 2 "execution time..." reports would not load at all. One of the other 4 failed with the same error, but loaded on a second round. Of the 4 all fail to run. I also could not get the ReadMe file to open. I think the docx format is an oversight. Not enough people are running 2007. I have it at home but not in the office. After 45 minutes of trying to get it to open, including installing the converter pack, I gave up. I will send it home and resave it and send it back to the office. What a pain, but I have to do it all the time.
This is a bit easier with the TFS Performance Report Pack – check it out: http://blogs.msdn.com/granth
any further development on getting these to work on SQL2005?
Can you make the pictures bigger when you click on them ?
Can these reports be available for SSRS 2005? upgrading the SQL Server 2008 is not an option right now. :)
TFS Performance Report Pack looks cool.
I have TFS 2008 running with SQL 2005...is it possible to make it happen with SQL 2005.
Since joining Microsoft, I’ve become intimately familiar with running a TFS server for ~3,500 users in
Here are some words of wisdom from our “go to” Engineer for TFS: My name is Brad Peterson and I am an
Grant Holliday has created a great set of TFS performance monitoring reports, called the TFS Performance