Changing update frequency and forcing a rebuild of TFS Warehouse

The reporting warehouse in TFS is a traditional data warehouse that consists of a relational database and an analysis services database. The data warehouse aggregates all the operational data, such as version control, Work Item tracking, build, and test. The warehouse corresponds to the Tfs_Warehouse relational database. The cube corresponds to the SQL Server Analysis Services database Tfs_Analysis. The default rebuild frequency for the TFS Warehouse is 2 hours. In this recipe, you'll learn how to manually change the TFS Warehouse refresh frequency from 2 hours to 1 hour. You'll also learn how to force a rebuild of the TFS Warehouse cube.

Note

TFS Warehouse refresh is default to 2 hours; if you reduce the interval to less than the default of 2 hours, processing of the data warehouse will consume server resources frequently. If your TFS Server has large volumes of data, reducing the refresh frequency may adversely affect the performance...