OVNPM 1.5.2 - Performance Agent for NonStop Server Monitoring Guide

46
Metric
Description
Recv-Qlen.nb
Average receive queue length for all inet belong a sockets instance
Writeread.nb/s
Disabled, not collected, for future use.
Messages.nb/s
Number of message sent for all inet:socket belong a SOCKETS instance
Read-Rate.KB/s
Data read or received for all inet/socket belong a SOCKETS instance.
Write-Rate.KB/s
Data write or send for all inet/socket belong the SOCKETS instance.
Io-Rate.KB/s
Total data transferred (sum Write-Rate.KB/s and ead-Rate.KB/s)
3-18 SQLPROC
The SQLPROC entity type provides information about one or more SQL processes.
3-18-1 SQLPROC Instance Configuration
Domain
SQLPROC
Description
The SQLSTMT entity type provides information about all SQL statements within a SQL
process.
Syntax sqlproc <process> [,<trendFlag>]
Where:
<process> is the name of any process executing SQL code.
Example
sqlproc $qnsql , Trend=ON
3-18-2 SQLPROC Metrics
Metric
Description
sql_obj_recompile_time
The time this process spent recompiling objects.
sql_stmt_recompiles
Number of statements recompiled for this process.
sql_stmt_recompile_time
The time this process spent recompiling statements.
sql_newprocesses
Number of NEWPROCESS calls generated by the SQL executor on behalf of this
process.
sql_newprocess_time
The time this process spent doing SQL-NEWPROCESS.
Opens
Number of OPEN calls performed by the SQL executor on behalf of this process.
open_time
The time this process spent doing OPENs.