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
Log on to the application-tier server.
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
From the WarehouseControlWebService page, click GetSettings, and then click Invoke.
A new browser window will open and display the values that are defined for each setting. For a description of each setting and the default values that are assigned to each setting, see Settings That Control Processing of the Data Warehouse and Analysis Services Cube.
Change the Refresh Frequency of the Data Warehouse
To change the refresh frequency of the data warehouse
From the WarehouseControlWebService page, click ChangeSetting.
In the settingID box, type:
RunIntervalSeconds
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
From the WarehouseControlWebService page, click ChangeSetting.
In the settingID box, type:
IncrementalProcessIntervalSeconds
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
From the WarehouseControlWebService page, click ChangeSetting.
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