Export (0) Print
Expand All

Settings That Control Processing of the Data Warehouse and Analysis Services Cube

In this topic you can learn about the settings that control processing of the data warehouse. All reportable data from all team projects that are defined in all team project collections for a deployment of Visual Studio Application Lifecycle Management (ALM) is written to a single relational database (Tfs_Warehouse). Data from that warehouse is then processed and written to the SQL Server Analysis Services cube (Tfs_Analysis). These two databases are the data warehouse for Team Foundation.

You should leave most of these settings at their default assignments. However, on occasion, you may have to modify a setting to meet your specific deployment requirements.

You can determine the current settings and change a setting by using the Warehouse Control Web service. For more information, see Change a Process Control Setting for the Data Warehouse or Analysis Services Cube.

The following table describes each process control setting and provides the SettingID, default value, and unit of measure.

SettingID

Default value

Description

AnalysisSchemaUpdateWaitSeconds

3600 (seconds)

Specifies the time-out that determines how long a job will wait in a running state to perform an update to the cube. If the time-out expires before the schema change finishes, the job quits and restarts later. This time-out interval supports jobs that require exclusive access to the data warehouse resources during the schema change stage.

AnalysisServicesProcessingTimeout

86400 (seconds)

Specifies the time-out, measured in seconds, that determines how long a job will wait for a processing call to Analysis Services to finish.

DailyFullProcessingTime

02:00:00.0000000-08:00

Specifies the time of day when the full processing of the Analysis Services cube is started. By default, it is set to 2 AM.

DataUpdateWaitSeconds

30 (seconds)

Specifies the time-out that determines how long a job will wait in a running state for another adapter that is making schema changes to finish, or for the analysis processing job that changes the cube schema to finish. This time-out is used by jobs to acquire shared access to the warehouse resources during the data change stage. If the time-out expires before the schema change process finishes, the job quits and restarts later.

FullProcessIntervalSeconds

86400 (seconds)

Specifies the frequency at which the cube is fully processed. The default value corresponds to 24 hours.

IncrementalProcessIntervalSeconds

7200 (seconds)

Specifies the frequency at which the cube is incrementally updated. The default value corresponds to two hours.

MaxParallelASProcessingCommands

0

Indicates the maximum number of commands that can run in parallel when Team Foundation processes calls to SQL Server Analysis Services. If set to 0, the instance of SQL Server determines the optimal number based on the number of processors that are available on the computer.

RunIntervalSeconds

120 (seconds)

Specifies the frequency at which the relational database is updated.

SchemaUpdateWaitSeconds

120 (seconds)

Specifies the time-out that determines how long a job will wait in a running state to acquire exclusive access to the schema change method. If the time-out expires before the schema change finishes, the job quits and restarts later.

WarehouseCommandSqlTimeout

3600 (seconds)

Specifies the time-out that determines how long a job will wait to acquire an exclusive access to a data warehouse resource.

Community Additions

ADD
Show:
© 2014 Microsoft