ASG_KPI Table

The ASG_KPI table stores information regarding the key performance indicators (KPI ) of the transactions stored in the ASG_TRANSACTIONS table to support visualizations. The central logger flushes the records in regular time frames as per the KPI configuration. You should use the ASG_TRANSACTIONS table for historical data analysis.

Columns of ASG_KPI Table
Field Name Description
KPI_TIMESTAMP The timestamp.
KPI_SUCCESS_CNT The count of successful transactions with status = OK.
KPI_FAILURE_CNT The count of failed transactions with status = INVALID/FAIL.
KPI_TIMEOUT_CNT The count of the timed out transactions.
KPI_ERROR_CNT The count of the transactions with error as response.
KPI_TOTAL_CNT The total number of transactions in a chosen period.
KPI_AVG_LATENCY The average time spent in the gateway, which measures the gateway overhead. The average KPI latency time for a transaction is calculated from the ASG_TRANSACTIONS table as below:

(Façade E Time – Façade Ingress Time – Router Egress Time – Router Ingress Time)

KPI_AVG_DURATION The average time between request and response message.

The average KPI duration for a transaction is calculated from the ASG_TRANSACTIONS table as below:

(Façade Egress Time – Façade Ingress Time)

KPI_TYPE The KPI dimension. The possible values are:
  • Engine
  • Operation
  • Partner
  • Service
KPI_ENTITY Unique value for the KPI dimension.
KPI_FREQUENCY The name of aggregation group such as kpi1m , kpi5m, kpi1h.
KPI_END_TIMESTAMP Specifies the end interval for the KPI type.