Why refresh data Warehouse?

1. Log on to the application-tier server.
2. Open Internet Explorer, type the following string in the Address bar, and then press ENTER:

   For VirtualDirectory, type the IIS Virtual Directory that was specified when Team Foundation Server was installed. By default, the virtual directory is tfs.

   The WarehouseControlWebService page opens.

   The Microsoft Team Foundation Server Application Pool must be running for the Warehouse Control Web service to be available.

To change the refresh frequency of the data warehouse

1. From the WarehouseControlWebService page, click ChangeSetting.
2. In the settingID box, type:

   RunIntervalSeconds

3. In the newValue box, type the new number in seconds, and then click Invoke.

   A confirmation Web page appears and indicates that the RunIntervalSeconds setting has been changed.

To change the refresh frequency of the cube

1. In the settingID box, type:

   IncrementalProcessIntervalSeconds

2. In the newValue box, type the new number in seconds, and then click Invoke.

   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.

   A confirmation Web page appears and indicates that the IncrementalProcessIntervalSeconds setting has been changed.

To change other process control settings of the data warehouse

1. On the ChangeSetting page, type an entry for the settingID and newValue, and then click Invoke.

   For a description of each setting and the default values and measures that are assigned to each setting, see .

   A browser window will open. The service indicates that the setting has been changed to the new value.