Share via


Change a Process Control Setting for the Data Warehouse or Analysis Services Cube

You can change the refresh frequency and time-out values that control the processing of the data warehouse. You change a process control setting only if you want to tune it for your specific deployment.

During processing, the warehouse adapters pull data from the operational store, transform it as necessary, and write it to the warehouse through the warehouse object model. During typical operations, the relational database (Tfs_Warehouse) is processed within two minutes of changes made to an operational store, and the SQL Server Analysis Services cube (Tfs_Analysis) is processed every two hours.

You might want to decrease or increase the length of time between refreshes to reduce the processing time or reduce the resource demands on the server. You can view the current settings or change a process control setting by using the Warehouse Control Web service.

In this topic

  • Access the Warehouse Control Web Service

  • Determine the Current Process Control Settings

  • Change the Refresh Frequency of the Data Warehouse

  • Change the Refresh Frequency of the Cube

  • Change Other Process Control Settings for the Data Warehouse

Required Permissions

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

Access the Warehouse Control Web Service

To access the Warehouse Control Web Service

  1. Log on to the application-tier server.

  2. Open Internet Explorer, type the following string in the Address bar, and then press ENTER:

    https://localhost:8080/VirtualDirectory/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

    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.

    Note

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

Determine the Current Process Control Settings

To view the settings that control processing of the data warehouse

Change the Refresh Frequency of the Data Warehouse

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.

Change the Refresh Frequency of the Cube

To change the refresh frequency of the cube

  1. From the WarehouseControlWebService page, click ChangeSetting.

  2. In the settingID box, type:

    IncrementalProcessIntervalSeconds

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

    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.

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

Change Other Process Control Settings of the Data Warehouse

To change other process control settings of the data warehouse

  1. From the WarehouseControlWebService page, click ChangeSetting.

  2. 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 Settings That Control Processing of the Data Warehouse and Analysis Services Cube.

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

See Also

Tasks

Manually Process the Data Warehouse and Analysis Services Cube for Team Foundation Server

Concepts

Managing the Data Warehouse and Analysis Services Cube