HP Neoview Release 2.4 Software - Manual (Page 40)

Description Metric
The amount of time used by Neoview SQL to execute the query. Query Elapsed Time
Total amount of processor (CPU) time utilized by the query. Display
format is hh:mm:ss (hour, minute, and seconds). Total Processor Time
Total amount of processor (CPU) time utilized by the query in the last
interval. Display format is hh:mm:ss (hour, minute, and seconds). This
is the value from the previous refresh interval. Last Interval Processor Time
Total amount of processor (CPU) time in microseconds utilized by the
query. This information is the same as the total processor time but uses
a different display format. Total Processor Time Microseconds
Time when the query information was last updated in WMS queues. Last Updated
Indicates how long a query was in a hold state. Hold Time
Rate-Based Metrics
Rate-based metrics indicate the rate of consumption of resources or rate of counters since the
previous time interval, which is the difference between the samples of the last 2 intervals
(current – previous)
. Depending on the version of the platform to which you are connected,
the information displayed will vary. This list provides a short description for the metrics:
Description Metric
Indicates the rate of rows being retrieved from the system. Because
Neoview SQL uses data-flow architecture, this counter depends on
the time and processing it requires to flow up a single row of results
back to the ROOT level operator. Rows/Second
Indicates the amount of processor (CPU) cycles the query is consuming
(rate of the processor usage). Processor Usage/Second
Indicates the difference between the current and previous sample of
the processor (CPU) utilization. Delta Processor Time
Indicates the difference (current – previous interval samples) in
the amount of megabytes (MB) of memory allocated by all the processes
involved with the query. Delta Space Alloc MB
Indicates the difference (current – previous interval samples) in
the amount of megabytes (MB) of memory used by all the processes
involved with the query. Delta Space Used MB
Indicates the difference (current – previous interval samples) in
the number of disk reads performed by all the processes involved with
the query. Delta Disk Reads
Indicates the difference (current – previous interval samples) in
the number of rows inserted, updated, or deleted. Delta IUD
Provides the rate of the number of rows inserted, updated, or deleted
per second. IUD/Second
Compile-Time Metrics
Compile-time metrics are used by Neoview SQL to generate query plans and provides a view
of the estimates of resources required by a query. This information is static for the life of a query
(meaning it does not change while a query executes). Depending on the version of the platform
40 Use the Live View Pane