Neoview Workload Management Services Guide (R2.5)

Run-Time Metrics
This table describes the runtime metrics for the query:
DescriptionName
Internal execution state of the query. For more information, please contact your
HP Support representative.
Exec State
Error code valueError Code
Top-level error code returned by the query, indicating whether the query
completed successfully or with warnings or errors. A positive number indicates
a warning. A negative number indicates an error.
Sql Error Code
Actual number of rows accessedRows Accessed
Actual number of rows returned after the predicates were applied. In a pushed
down plan, all the used rows might not be returned.
Used Rows
Number of gigabytes (GB) of memory allocatedSpace Allocation Gb
Number of gigabytes (GB) of memory usedSpace Usage Gb
Number of kilobytes (KB) of memory allocatedTotal Space Alloc Kb
Number of kilobytes (KB) of memory usedTotal Space Used Kb
Number of bytes returned for the statistics countersStats Bytes
Number of disk-read operations for accessing all the tables referenced by the
query
Disk Reads
Number of lock waits. This counter indicates the number of times the query had
to wait on a conflicting lock. A value of 0 indicates that no locks were
encountered while the query was executing.
Lock Waits
Number of lock escalations. This counter indicates the number of times row
locks escalated into a file lock during the execution of the query. A value of 0
indicates that no locks were escalated while the query was executing.
Lock Escalations
Number of opens (one per partition), which is the number of OPEN calls
performed by the Neoview SQL executor on behalf of the query
Opens
Number of messages sent to execute operations on the tables used by the queryMessages To Disk
Number of messages bytes sent while accessing the tables used by the queryMessage Bytes To Disk
Number of rows inserted, updated, or deletedNum Rows Iud
Internal error code returned to the statistics collector from the runtime statistics
(RMS) infrastructure
Stats Error Code
Number of Executor Server Processes (ESPs) createdProcesses Created
Processor (CPU) utilization, in seconds, spent by the disk process to execute the
query
Disk Process BusyTime
Processor (CPU) utilization, in seconds, by Neoview SQL for the querySql Cpu Time
Amount of time, in seconds, to create Executor Server Processes (ESPs)Process Create Time
Amount of time, in seconds, spent on opens for the queryOpen Time
Total space allocation by Neoview SQL for the querySql Space Alloc
Total space used by Neoview SQL for the querySql Space Used
Total heap allocation by Neoview SQL for the querySql Heap Alloc
Total heap used by Neoview SQL for the querySql Heap Used
Total space allocation by the executor in the disk processEid Space Alloc
136 Monitoring and Managing Workloads