How to change update frequency of the TFS warehouse/cube
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):
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):
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)