TFS2010: Update Activity Logging Cleanup Interval

Every command that a user executes in TFS is logged to the database. This is very useful for investigating performance issues and other things. I’ve blogged before about how to query this table for TFS2008. Those same queries work for TFS2010 as well. By default, each night a job runs that deletes log entries older…


Getting Started with TFS Hosting from DiscountASP.NET

With the recent reorganization of SPLA prices for Team Foundation Server, there’s been some new offerings in the Hosted TFS space. I’ve blogged about other TFS hosting services in the past and there’s a list of the companies that provide TFS hosting services here. Now there’s a new player in the hosted Team Foundation Server…


Monitoring the TFS Data Warehouse – FAQ

This blog post describes how to interpret the Data Warehouse & Cube status reports included in the Administrative Report Pack for TFS2010. Should I expect some processing jobs to fail? Why might most processing jobs fail? Why might many Incremental jobs be upgraded to Full jobs? Why might a processing job run for a very…


Administrative Report Pack for Team Foundation Server 2010 and 2012

Update Dec 2012: This report pack works unmodified on TFS2012 as well as TFS2010. One of the key components of TFS is the Data Warehouse, which is made up of a relational database and an Analysis Services cube.  In general, people don’t have a problem with the performance or operation of our Data Warehouse.  However…


TFS2010 Upgrade: Compatibility of tools

When you upgrade from Team Foundation Server 2008 to 2010, one of the things you need to check is the compatibility of the tools that people rely on and use the server with. Without careful preparation this can have a significant impact on your user’s experience after the server is upgraded. As an example, when…


TFS2010: How to query Work Items using SQL on the Relational Warehouse

In John Socha-Leialoha’s blog post on Upgrading Team Foundation Server 2008 Reports to 2010, Part I, there is a hidden gem: For the first time, writing reports against the warehouse using SQL is officially supported. As a rule of thumb, you’ll generally want to use the cube for historical reports, or reports that require a…


TFS2010: How to enable compression for SOAP traffic

When we upgraded our internal servers to TFS2010, some of our remote users noticed that HTTP compression was used for some traffic, but not all. HTTP compression was enabled for file downloads from source control and for web access pages but we weren’t compressing the SOAP responses to clients for Work Item Tracking and other…


TFS2010: Large & Resumable Check-in Support

Problem The DevDiv mainline contains over 200GB of content and more than 1.8 million files. Any version control operations that had to deal with this amount of content would occasionally run into two problems: If the number of pending changes is more than ~300,000, then the client might not be able to process all this…