TFS & Visual Studio ALM – by Neno Loje

(formerly Team System, VSTS)

How to change update frequency of the TFS warehouse/cube

June 13th, 2011 · No Comments · TFS Reporting, Tools and Utilities

By default TFS 2010 updates its warehouse every 2 hours.

You can change the frequency by running the WarehouseControlService SOAP webservice, as explained in this article.

Furthermore the webservice exploses some more settings as well.

To force the warehouse to update immediately, you can use the TfsRefreshWarehouse tool.

To make it easier to change the default frequency, you can use this command line tool:


To shorten the interval down to 1 hour (= 3600 seconds):

TfsWarehouseController.exe /server:http://localhost:8080/tfs
/name:IncrementalProcessIntervalSeconds /value:3600

Please be aware of this warning, taken out streigt from MSDN:


If you reduce the interval to less than the default of two hours (7200 seconds), processing of the data warehouse will consume server resources more frequently. Depending on the volume of data that your deployment has to process, you may want to reduce the interval to one hour (3600 seconds) or increase it to more than two hours.

There’s also a /list parameter that shows all current settings (without making any changes):

White text on black background makes me happy...

Download the tool from here: TfsWarehouseController.exe (.ZIP, 12,00 KB)

Prerequisite: This tool requires Team Explorer 2010 to be installed.

Required Permissions: Administer Warehouse (TFS server-level permission)


No Comments so far ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment