OVNPM 1.5.2 - Performance Agent for NonStop Server Monitoring Guide

OVNPM Entities 47
3-19 SQLSTMT
The SQLSTMT entity type provides information about all SQL statements within a SQL process.
3-19-1 SQLSTMT Instance Configuration
Domain
SQLSTMT
Description
The SQLPROC entity type provides information about one or more SQL processes.
Syntax SQLSTMT <process>.<runUnit>[.#<index>]
Where:
<process> is the sql process name.
<runUnit> is the procedure in that process executing sql statement.
<index> is the index of the statement to be measured. If omitted, OVNPM uses index
0.
Example
sqlstmt $qasql.InsertInCustTable.2 , trend=off
3-19-2 SQLSTMT Metrics
Metric
Description
calls
Number of times the measured SQL statement was executed.
elapsed_busy_time
The time the process spent executing the measured SQL statement.
records_used
Number of records inserted, updated, deleted, or read by the SQL executor through this
statement.
records_accessed
Number of records accessed by the disk process or file system to evaluate this
statement.
disc_reads
Number of physical disk reads performed for this statement. If the REPORT RATE value is
on, the rate is disk reads for each second.
Messages
Number of messages sent by the system on behalf of this statement, including messages
sent by the file system to the disk process and messages sent by the SQL executor to the
SQL compiler for recompiles.
message_bytes
Number of message bytes sent for this statement by the system. This counter
accumulates the number of bytes sent for the messages reported by the MESSAGES
counter.
Sorts
Number of times an external sort process was invoked for this statement.
Elapsed-Sort-Time
The time spent by the process on sorts for this statement.
Recompiles
Number of times the statement was recompiled.
Elapsed-Recompile-Time
The time the process spent recompiling this statement.
Lock-Waits
Number of times this statement waited for a lock request.
Timeouts Number of times a request timed out. A timeout is caused by either a lock-wait or a
congested disk process or network.
Escalations
Number of times a record lock was escalated to a file lock.
OVNPM Entities