OVNPM 1.5.2 - Performance Monitor User and Installation Guide

HP Performance Monitor Database Schema 38
6-2-2 Metric Data Tables
Metric data tables contain the metric counter data information. These tables include variable data that keeps on
updating from the back end. PM Logger keeps on inserting the collected performance metric data into these
tables. The column names in data tables are the metrics defined on the back end for a particular domain.
Domain APPLIDEF
The APPLIDEF domain represents a group of processes that define an application.
Column Name
Data Type
Description
instanceId
Integer
Specifies the instance id.
day
Varchar(50)
Specifies the day.
Sum-Cpu-Busy.% float Percentage of time that the APPLIDEF processes were executing
in the CPU.
Sum-Dispatches.nb/s
float
Number of times per second that these APPLIDEF processes
were dispatched.
Sum-Page-Faults.nb/s
float
Number of Page faults per second during the sample period
Sum-IO-Rate.Kb/s
float
Number of kilobytes per second handled by these APPLIDEF
processes during the sample period. This includes sent-bytes and
returned-bytes, as well as received-bytes and reply-bytes.
Sum-Msg-Sent.nb float Number of messages sent by the APPLIDEF processes to other
processes.
Sum-Msg-Rcvd.nb
float
Number of messages received by the APPLIDEF processes.
Sum-Ready-Time.% float Percentage of time that APPLIDEF processes spent on the ready
list or executing.
Sum-Mem-QTime.%
float
Percentage of time that APPLIDEF processes were on the ready
list and waiting on page fault.
Sum-Pres-Pages-
Max.nb
float Maximum number of pages owned by the APPLIDEF processes
spent in main memory.
Sum-Ext-Segs-Max.nb
float
Maximum number of extended segments used by the APPLIDEF
processes.
Sum-Rcv-Qlen-Max.nb
float
Maximum number of messages waiting on $RECEIVE.
Sum-Max-Lcbs-
Inuse.nb
float
Maximum number of Link Control Blocks allocated to the
APPLIDEF processes.
Sum-Checkpoints.nb/s float Number of checkpoints per second executed by the APPLIDEF
processes.
Sum-Accel-Busy.%
float
Percentage of time that the CPU was busy executing accelerated
code for the APPLIDEF processes.
Sum-Tns-Busy.% float Percentage of time that the CPU was busy executing TNS code
for the APPLIDEF processes.
Sum-Comp-Trap.nb/s
float
Number of times per second a compatibility trap occurred on
the processor for the APPLIDEF processes.
Avrg-Cpu-Busy.% float Average percentage of time that one APPLIDEF process was
executing in the CPU.
Avrg-Dispatches.nb/s
float
Average number of times per second that one APPLIDEF process
was dispatched.
Avrg-Page-Faults.nb/s float Average number of Page faults per second during the sample
period.
Avrg-Io-Rate.Kb/s
float
Average number of kilobytes per second handled by one
APPLIDEF process during the sample period. This includes sent-
bytes and returned-bytes, as well as received-bytes and reply-
bytes.