Rate (rolled up, condensed) information
Raw performance data is statistically computed and rolled into hourly data called Rate data. This enables you to retain data for an extended period of time (90 days) without increasing disk storage or having a negative impact on database performance.
Creating views for Rate data is relatively easy for most monitor types as data is organized in individual (horizontal) tables. This enables a one to one mapping of a Rate table to a view for each monitor type that is available in the Infrastructure Management system. Rate dataviews are named as <tablename prefix>_RT_VIEW. Each of these Rate dataviews contains the following information:
Rate Information
Column | Description |
|---|---|
MOINSTID | Monitor instance ID. This is a unique number generated for each instance. The value is assigned by the Infrastructure Management system during monitor creation. This value is internal and fixed. This number identifies all other data for each instance. |
FROMTIME | UNIX time stamp for the start of the duration |
TOTIME | UNIX time stamp for the end of the duration |
Stats Attribute NameAVG_Stats Attribute NameHIGH_Stats Attribute Name_LOW | This contains Rate values for the above FROMTIME to TOTIME duration. Each attribute of this monitor type has three Rate values. |