Resource allocation

Deployment options: Netezza Performance Server for Cloud Pak for Data System

Specifies the percentage of current system resources consumed by top 4 resource groups.

The charts show the current and historical resource allocation for specific groups. It's to provide the resource allocation based on the resource groups.

The first chart monitors the percentage of system resources that are consumed by the resource groups over the time.

The other two pie charts show the current resource allocation and current run jobs of the top 4 resource groups.

Supporting queries:

select * from (select start_time, end_time, groupname, target_rsg_pct, actual_rsg_pct, plans_running_short, plans_running_long, plans_waiting_short, plans_waiting_long, target_rsg_max, allowed_rsg_pct from _v_sched_gra_ext_latest where groupid not in (4900,0) union  select start_time, end_time, groupname, target_rsg_pct, actual_rsg_pct, plans_running_short, plans_running_long, plans_waiting_short, plans_waiting_long, target_rsg_max, allowed_rsg_pct from _v_sched_gra_ext where groupid not in (4900,0)) subquery order by end_time, lower(groupname) desc LIMIT 1000;

select groupname as name, actual_rsg_pct as allocation from _v_sched_gra_ext_latest where groupid not in (0,4900);

select groupname as name, (plans_running_long + plans_running_short) as jobs from _v_sched_gra_ext_latest where groupid not in (0,4900);