OVNPM 1.5.2 - Performance Agent for NonStop Server Monitoring Guide

78
Metric
Description
TmOutCancl (TimeoutsOrCancels)
Number of time-outs or cancels issued.
UpdOrRepli
Number of update or reply operations made by the current process.
Writs (Writes)
Number of write operations.
WrRds (WriteReads)
Number of write/read operations.
Metrics on SQL process:
Metric
Description
ObjRecomp
Number of objects recompiled for the process.
ObjRecompTime
Percentage of time the process spent recompiling objects.
StmtRecomp
Number of statements recompiled for the process.
StmtRecompTime
Percentage of time the process spent recompiling statements.
NewProcesses
Number of newprocess calls generatedby the SQL executor.
NewProcessesTime
Percentage of time the process spent during newprocess calls.
Opens
Number of open calls performed by the SQL executor.
OpenTimes
Percentage of time the process spent during open calls.
Metrics on SQL statements within an SQL process:
Metric
Description
Procedure or Run Unit
SQL statement procedure name.
StmtIx
SQL statement index number within the run unit.
Calls
Number of times the statement was executed.
ElapsBusy
Percentage of time the process spent executing the statement.
RecUsed
Number of records inserted, updated, deleted or read by the SQL executor through the
statement.
RecAccess
Number of records accessed by the disk processor file system to evaluate the statement.
DiscRead
Number of physical disk reads performed for the statement.
Messages
Number of messages sent for the statement.
MsgBytes.
Number of messages bytes sent for the statement
Sorts Number of times an external sort process was invoked for the statement.
ElapsSort
Percentage of time spent by the process on sorts for the statement.
ReComp
Number of times the statement was recompiled.
ElapsRecomp
Percentage of time the process spent recompiling the statement.
LockWait
Number of times the statement waited for a lock request.
TimeOut
Number of times a request timed out
Escal Number of times a record lock was escalated to a file lock.