Re: Performance tuning

One of our customers asked how to improve performance on their P8
system with 8 CPUs y SSDs, because they were hitting 80% on a regular
day and 100% when close to EOM process, and system was dying. They
have 2000 users and 100% SQL code, no RPG.
They were thinking of moving to a 20 CPUs and 10 IBM i licenses on P9
system, "just in case". We found the issue was memory + need for an OS
upgrade + some applicantion bad practices.
They add memory, make some quick-win changes on applications and
upgraded from V7R1 to V7R2.
Today they have 30% average CPU usage, with 60%~80% on EOM process.
How much have they saved? 500K~750K USD

I agree... a lot of resources lowers your tickets, but sometimes you
need some tuning and it pays itself.

El vie., 30 nov. 2018 a las 12:31, Rob Berendt (<rob@xxxxxxxxx>) escribió:

Sometimes throwing money at hardware isn't always the answer. Our
original foray into SSD's was a big disappointment. Much less money for a
much larger return on investment would have been to buy the "HA Journal
Performance" option as part of SS1. I daresay it will be a rare
consultant who can pinpoint WHY you might need that and predict how much
it will help.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Rob Berendt" <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 11/30/2018 01:26 PM
Subject: Re: Performance tuning
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Actually, so many things change over the time that it does become
something of an art. For example, WRKSYSSTS can show you faulting and
paging information. So, what are high numbers? This is a fluid thing.

What do the high numbers indicate? Are they the problems of memory pools,

poorly written applications, starved memory?

At consultant rates for someone else to do it you might just find the
money is better spent throwing it at hardware.
And some consultant who still calls it an AS400 is probably not going to
be able to say "well you need to change this setting on your HMC..." or
"instead of one big space on IBM i hosting IBM i you should probably bust
that up into multiple storage spaces spread across x number of network
storage devices"



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com