Data Warehouse

The Data Warehouse tab allows you to configure attributes for the BMC TrueSight Capacity Optimization Warehousing engine. This launches multiple threads for the warehousing activities. You can access this tab by navigating to Administration > System > Global configuration > Data Warehouse.

BMC TrueSight Capacity Optimization data warehousing activities are executed within Datahub component through (Near-Real-Time) Warehousing Engine (NRT WH). The NRT WH stores, organizes, and calculates statistics for collected data.

Option

Description

Number of spare threads

Maximum number of concurrent threads activated by the warehousing process and dispatched among queued requests.

Sleep period

Period (in milliseconds) between subsequent polling, when the executor of the activity is in sleep mode.

Freshness timeout

Minimum interval between processing of the same series in the same step. You can use to avoid multiple reduction of the same series within the day.

Limit

Maximum number of active threads for the step.

Reserved

Number of reserved/dedicated threads to the step. Reserved threads are permanently available without requiring spare threads.

Weight

Weight assigned to a step. In case of contention on spare threads, you can use weight to prioritize the assignment.

Each attribute can be specified using an inheritance/override mechanism. 

The primary way to tune Data Warehouse configuration is to only change the number of Spare threads. It is recommended that you retain the default values for the Reserved threads.


Default values for the available options for the thread launchers are as follows:

Number of Spare Threads: 20

Thread launcherSleep periodFreshness TimeoutLimitReserved
Store (store) 5 min050%*spare0
Warehouse (wh) 10 min15 min40%*spare0
Reduce (red) 10 min8 hours50%*spare0
Configuration Metrics (conf) 1 min1 hour40%*spare0
Custom Statistic (cs)10 min8 hours15%*spare0
External Custom Statistic (ecs) 10 min5 min30%*spare0
Raw (raw) 1 min30 sec30%*spare0
Was this page helpful? Yes No Submitting... Thank you

Comments