System metrics, Processing node utilization, Processing node queue length – HP Neoview Release 2.4 Software User Manual
Page 24: Memory usage, Cache hits, System i/o activity, Workload metrics
System Metrics
The System Metrics tool is a shortcut to select the default system metric tools in a single view.
Clicking on this icon will add these tools to the workspace: Processing Node Utilization, Processing
Node Queue Length, Cache Hits, and System I/O Activity. The default aggregate function for
Processing Node Utilization and Processing Node Queue Length is an average function. The
other metrics use a total (or sum) aggregate function by default.
Processing Node Utilization
The Processing Node Utilization tool provides details about the processor node busy time on
the Neoview platform. The default aggregate function is an average percentage value of each
individual node over 5–minute time intervals and indicates the Neoview platform utilization
rate. This percentage value is an average across all the nodes (on all the segments) that make up
the Neoview platform. A high percentage value indicates a high Neoview platform utilization
rate and a lower percentage value indicates a lower Neoview platform utilization rate.
Processing Node Queue Length
The Processing Node Queue Length tool displays the number of processes that were on the ready
list at particular points in time. The default aggregation function is an average function of the
queue lengths of each individual node on the Neoview platform over 5–minute intervals.
A higher queue length value points to more processes waiting on the query list. This might
indicate
•
Some queries (processes) are waiting for resources that are in use by another process.
•
The load on the system is really high. While this might not be indicative of node processing
busy time, it could point to a resource consumption problem on the Neoview platform.
Memory Usage
The Memory Usage tool graphs the total memory utilization across all individual processing
nodes on the Neoview platform. This metric value is the sum of all the nodes over a 5-minute
interval across the Neoview platform and is an indicator of the memory pressure on the system.
Cache Hits
The Cache-Hits tool graphs the total number of times a required data block was found in the
disk cache for disk I/O operations. This indicator is a sum of all the cache hits that occurred on
all the individual nodes of the Neoview platform over a 5-minute interval. A higher number of
cache hits will result in better query performance.
System I/O Activity
The System I/O Activity tool graphs the total number of disk transfers (I/O operations) that
occurred on the Neoview platform over 5-minute intervals. This indicator is a sum of all the disk
I/O operations initiated on the Neoview platform.
Workload Metrics
The Workload Metrics allow you to specify a workload filter to graph metrics specific to
workloads. This enables you to view the performance of a workload over a period of time and
make improvements to the workload distribution as well as provide for whether a user may
need to tune or optimize a particular workload. You can create as many workload graphs as you
need. To graph the Workload Metrics, follow these steps:
24
Use the Workspace Toolbox