Performance (stats, raw) data

Performance data, also called raw data or stats data, is the attribute performance values collected during every poll of a monitor instance. Creating views for stats data of most monitor types is relatively easy, as data is organized in individual (horizontal) tables, which allow one-to-one mapping of stats table to a view for each monitor type available in the Infrastructure Management system.

MetaAPI application monitors' stats data is the exception to this rule and is organized in a single (vertical) table by attribute of each monitor. To address this about, a view for each Stats attribute is created and a view joining these views is created to give the effect of a horizontal table. The final view is the same as views created for other monitors. As a result, accessing MetaAPI monitor views is performance intensive.

Accessing stats data from a view is advantageous as values stored in the tables are multiplied by a scale factor that is different for each attribute and monitor type. Configuration data 'Configuration dataviews (<tablename prefix>_CFG_VIEW)' and Stats dataviews can be joined on the MOINSTID column to get all information related to an instance.

Stats dataviews are named as <tablename prefix>_ST_VIEW. Each of these Stats dataviews contains the following information:

Performance information