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:

Syntax/Usage:

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:

Important

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)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>