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 ...
Get Microsoft Team Foundation Server 2015 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
