TFS QA - How do I change the processing interval for the Data Warehouse?
Team Foundation Server synchronizes the relational databases and the OLAP database, typically used for reporting, on an hourly basis by default. This behaviour can be confusing for project managers, for example, who typically produce a report after applying a bulk of status changes, only to find that the changes are not reflected. They are likely to be processed, but not synchronised to the OLAP database.
- You can start a synchronisation by typing the following URL: http://<@@TFS@@>:8080/Warehouse/v1.0/warehousecontroller.asmx
where @@TFS@@ is the name of your TFS Server. - Select Run, to start the synchronisation process.
Alternatively you can change the interval to be less or greater than the default hourly update:
You can start a synchronisation by typing the following URL: http://<@@TFS@@>:8080/Warehouse/v1.0/warehousecontroller.asmx?op=ChangeSetting
where @@TFS@@ is the name of your TFS Server. Type RunIntervalSeconds for the settingID parameter. Define the interval in seconds in the newValue property. Click invoke to apply the changes.