How to: Change the Data Warehouse Refresh Frequency

The data warehouse service periodically calls the warehouse adapters. The adapters then pull data from the operational store, transform it as necessary, and write it to the warehouse through the warehouse object model. The default frequency for running the adapters and refreshing the warehouse is 3,600 seconds (1 hour). You may want to increase the length of time between refreshes to reduce the processing time and other resource demands on the server.

You can change the refresh frequency by connecting to the warehouse Web service and using the standard ControllerService user interface. Contact your Team Foundation Server administrator or your team project administrator to make sure that your user account has the permissions described in the following section.

Required Permissions

To perform this procedure, you must be a member of the Team Foundation Administrators security group or have the server-level Administer warehouse permission set to Allow. For more information, see Team Foundation Server Permissions.

To change the refresh frequency using the Web service interface

  1. Log on to the application tier of Team Foundation Server.

  2. Start Internet Explorer.

  3. In the Internet Explorer Address box, type https://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx.

  4. On the ControllerService page, click ChangeSetting.

  5. In the settingID box, type RunIntervalSeconds.

  6. In the newValue box, type the new number of seconds, and then click Invoke.

    This opens a confirmation web page which indicates that the RunIntervalSeconds setting was changed.

See Also


Understanding the Data Warehouse Architecture

Other Resources

Setting Properties for the Data Warehouse