Custom VPPerformance Reports

Last Updated : Jun 23, 2021 |
Prolog information
Metadata
Keywords:
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.
Primary key columns
Name
VPID
MPP
Time
ResourceID
ComponentID
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.