Resource consumption
Deployment options: Netezza Performance Server for Cloud Pak for Data System
Netezza Performance Server for Cloud Pak for Data
The resource monitor summarizes several key system resources for the monitored system.
These charts display information about the overall CPU, disk, fabric network, and memory
utilization of the monitored system. This graph shows the consumption of system resources on a
select percentage of the SPU. .png)
The query that is
used:
set timezone to gmt; select DATE_PART('epoch', current_timestamp) as timestamp, avg(HOST_CPU) * 100.0 as
host_cpu_percent, avg(SPU_CPU) * 100.0 as spu_cpu_percent, max(MAX_SPU_CPU) * 100.0 as max_spu_cpu_percent,
avg(HOST_MEMORY) * 100.0 as host_memory_percent, avg(SPU_MEMORY) * 100.0 as spu_memory_percent,
max(MAX_SPU_MEMORY) * 100.0 as max_spu_memory_percent, avg(HOST_FABRIC) * 100.0 as host_fabric_percent,
avg(SPU_FABRIC) * 100.0 as spu_fabric_percent, max(MAX_SPU_FABRIC) * 100.0 as max_spu_fabric_percent,
avg(HOST_DISK) * 100.0 as host_disk_percent, avg(SPU_DISK) * 100.0 as spu_disk_percent, max(MAX_SPU_DISK) *
100.0 as max_spu_disk_percent from _vt_system_util where entry_ts / 1000000 > ((select max(entry_ts) from
_vt_system_util) / 1000000 - 180)The Utilization trend charts display the recent history of these consumption indicators. You can use the slider or zoom in and out at the bottom of the chart to see a specific range such as the previous 1 hour, 6 hours, 12 hours, previous 24 hours, or a custom range.
If the chart shows an unexpected or interesting change in the trend, you can drill down to take a closer look at the time frame and jump to the query history for that time frame.