The vpperformance report contains performance statistics for each MPP in the Experience Portal system. This information is obtained from the MPP heartbeat request and is aggregated over a configured period (5 minutes by default). Statistics are identified by the ResourceID and apply to a specific time interval and a specific MPP server in the cluster. This table has one row for each statistic, for each MPP in a cluster, for each time interval in which an MPP heartbeat response was received. Rows are created upon completion of each aggregation period. Rows are deleted according to an administrable data retention limit.

Table 1. Primary key columns

Name

VPID

MPP

Time

ResourceID

ComponentID
Table 2. Columns

Column

Data Type

Description

VPID

INTEGER

Identifies the EP system , within a cluster of multiple EP systems that merge the data into the same external database. If there is only one EP system at an installation, this field will always be 1.

MPP

VARCHAR2(256)

The unique name assigned to this MPP through the EPM.

Time

VARCHAR2(64)

Timestamp of the aggregated statistic.

ResourceID

VARCHAR2(256)

Name of the statistic to which this row applies:

  • CPU - Percentage of CPU utilization

  • Disk - Percentage of disk utilization

  • Memory - Percentage of memory in use

  • Port - Percentage of licensed telephony resources currently in use

  • Inbound Calls - Total active inbound calls

  • Outbound Calls - Total active outbound calls

Duration

INTEGER

Time period that the data represents in milliseconds.

Sum

INTEGER

Sum of all the statistics taken in the aggregation period.

Count

INTEGER

Number of statistics taken in the aggregation period (number of heartbeats).

Peak

INTEGER

Largest statistic taken in the aggregation period.

Minimum

INTEGER

Smallest statistic taken in the aggregation period.

CurrentResource

INTEGER

Last value received from the heartbeat in aggregate period.

SourceType

INTEGER

Type of system resource is from:

  • 0 = MPP

  • 1 = EPM Primary

  • 2 = EPM Secondary

  • 3 = Overall Experience Portal

  • 4 = OM Stat

ComponentID

INTEGER

The component ID from AMS for OM statistic. The value in this column is populated when the value of SourceType is equal to 4. This column was added in Experience Portal 6.0.