Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

The collector for calculation is /DVD/MON_CA_CL_COL_CALC.

The collector collects KPIs with a defined calculation function in the Input table. The KPIs are defined through KPI definition and the Input table /DVD/MON_CA_KDEF.

The Input table /DVD/MON_CA_KDEF sets up the calculation function for a KPI. The Input table contains the following fields:

KPI name

The same technical name as in the KPI definition

Function

Calculation function

Changed by

Last change by user [automatically filled]

Changed at

Last change date and time [automatically filled]

Created by

Created by user [automatically filled]

Created at

Created date and time [automatically filled]

Functions for calculations

KPI() – Function KPI() returns collected values of KPI in a time range.

          Parameters: only one KPI

AVG() – Calculates the average of values.

MAX() – Selects the maximum value.

MIN() – Selects the minimum value.

SUM() – Function sum of all values.

DIFF() – Function subtract for all values.

MUL() – Multiplication of all values.

DIV() – Dividing values.

Parameters for functions above:  

  • only one KPI
  • more constant values
  • more functions
  • combination of constants and functions


Examples

KPI(DB_CPU_LOAD5_P) – returns all values in a time range

MAX(KPI(DB_CPU_LOAD5_P)) – gets maximum of values from KPI

MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60) – gets maximum of two values,

-        the first parameter is MAX(KPI(DB_CPU_LOAD5_P))

-        and second is the threshold – 60

DIV(MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60), 60) – divides maximum from

-        function MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60)

-        and threshold – 60


Example of an Input table

KPI name

Function

CF_THRESHOLD

DIV(MAX(MAX(KPI(DB_CPU_LOAD5_P)), 90), 90)

ZCALC_FUNCTION

MAX(KPI(CPU_IDLE))


This KPI is provided in the CrystalBridge® Monitoring delivery with this collector:

KPI name

Description

Unit

CF_THRESHOLD

Value relative to the threshold of a KPI

Count

  • No labels