Re: New Navigator, Charting, Can I chart paging and/or faulting?

So I understand, you would want to notice a need for memory then have the a process add memory to the LPAR.
that seems doable, but complicated.

How much memory to add?
Performance tuning is more "art form" than "give it X"
How much memory is available(on Frame) to add to LPARs?
Have to get that from the HMC.
Is the LPAR at or near its configured max memory value?
Have to get that from the HMC.
DLPAR and add some memory to the LPAR.
Have to get do that on the HMC.

(reverse the process when the LPAR levels out)

might be easier to just add memory across all LPARs :-)

Bryan



Rob Berendt wrote on 1/14/2022 7:18 AM:

Assignment: We have memory available that is not assigned to any lpar. Put it to use on lpars.
Situation: All lpars of IBM i have QPFRADJ set to automatic and at IPL. Why is outside the scope of this thread.
There is an lpar of AIX on two of the three power systems but I recently gave them extra memory so we'll assume they are ok.

Thought: Give the memory to those lpars with the most paging and/or faulting.
Question: Can I use the charting in the New Navigator to determine that? If so, how?
Currently I see as possible metrics:

- CPU Average Utilization

- System ASP used

- Active Job Number
But it's all SQL, right? Maybe some stuff from https://www.ibm.com/docs/en/i/7.4?topic=services-memory-pool-info-view

Perhaps something like this:
select system_pool_id, pool_name, current_size,
elapsed_non_database_faults, elapsed_non_database_pages
from qsys2.memory_pool_info
order by elapsed_non_database_faults + elapsed_non_database_pages desc
fetch first row only
;


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com