This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
BMC Capacity Management
TrueSight Capacity Optimization 11.5, 11.3.01, 11.0, 10.7, 10.5, 10.3, 10.0
The PV_SYS_DATA_ROLL public view is a view into the SYS_DATA_ROLL table which contains rolling statistics for a select set of metrics. The SYS_DATA_ROLL data is often used as the basis for reporting 95th percentile CPU Utilization and other metrics in the Capacity Views.
Which metrics are available in the SYS_DATA_ROLL table?
Is it possible to add custom metrics to the SYS_DATA_ROLL table if they aren't available there?
How do I query data from the SYS_DATA_ROLL table?
The SYS_DATA_ROLL table (and the PV_SYS_DATA_ROLL public view) only includes a predefined list of metrics for particular entity types. There is no functionality avialable in TSCO for users to extend the metrics included in the SYS_DATA_ROLL table.
I don't see the CPU_LIMIT_MAX metric as one defined for inclusion in the SYS_DATA_ROLL rolling statistics table.
The following SQL can be run to list the metrics which will have rolling statistics calculated for them in the SYS_DATA_ROLL table by TSCO;
- TrueSight Capacity Optimization