Custom VPPerformance Reports

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.