How to change update frequency of the TFS warehouse/cube - TFS & Visual Studio ALM - by Neno Loje

TFS & Visual Studio ALM - by Neno Loje

(formerly Team System, VSTS)

News

Recent Posts

Community

Tags

Email Notifications

VSTS Blogs

VSTS Community

My Other Blogs

German VSTS Websites

Archives

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)

Comments

Willy's Cave said:

Projects News CodedUI ( VSCUG ) project is in the middle of sprint 5 and still focusing on in-depth guidance

# July 31, 2011 6:44 PM