how much cpu does Informix use

how much cpu does Informix use

Post by Floyd Well » Fri, 28 Mar 2008 22:12:33


lt;div>IDS10 on AIX 5.3.</div>
<div>Sorry if this has been asked before, but I still don't have a satisfactory answer.</div>
<div>We are trying to determine exactly how much percentage of our system cpu, that Informix is using through time. </div>
<div>This is proving to be a difficult task, because sar doesn't provide process names or id's so that I can correlate a percentage to 'oninit'.</div>
<div>ps command doesn't provide percentage.</div>
<div> </div>
<div>I am thinking that at least I can use onstat -g glo, add up all of the total time for cpu vps ( because I think those are the metrics of what oninit does on the physical cpus ).</div>
<div> </div>
<div>First question: Am I correct that only the cpuvps are directly tied to the physical cpus? Or do I need to be counting all of the vps ?</div>
<div> </div>
<div>Second question. The numbers provided for each cpu is what ? Seconds ?</div>
<div>So, assuming that oninit has been up the entire time that the lpar has been up, if I divide the total time from onstat -g glo by the number of seconds since the lpar has been up, will that tell me the percentage of cpu that oninit uses ?</div>
<div> </div>
<div>Thanks for any advice on this.</div>
<div> </div>
<div>Floyd</div>
<div> </div>
------=_20080327081233_21119--

IDS10 on AIX 5.3.
Sorry if this has been asked before, but I still don't have a satisfactory answer.
We are trying to determine exactly how much percentage of our system cpu, that Informix is using through time.
This is proving to be a difficult task, because sar doesn't provide process names or id's so that I can correlate a percentage to 'oninit'.
ps command doesn't provide percentage.

I am thinking that at least I can use onstat -g glo, add up all of the total time for cpu vps ( because I think those are the metrics of what oninit does on the physical cpus ).

First question: Am I correct that only the cpuvps are directly tied to the physical cpus? Or do I need to be counting all of the vps ?

Second question. The numbers provided for each cpu is what ? Seconds ?
So, assuming that oninit has been up the entire time that the lpar has been up, if I divide the total time from onstat -g glo by the number of seconds since the lpar has been up, will that tell me the percentage of cpu that oninit uses ?

Thanks for any advice on this.

Floyd

<div>IDS10 on AIX 5.3.</div>
<div>Sorry if this has been asked before, but I still don't have a satisfactory answer.</div>
<div>We are trying to determine exactly how much percentage of our system cpu, that Informix is using through time. </div>
<div>This is proving to be a difficult task, because sar doesn't provide process names or id's so that I can correlate a percentage to 'oninit'.</div>
<div>ps command doesn't provide percentage.</div>
<div> </div>
<div>I am thinking that at least I can use onstat -g glo, add up all of the total time for cpu vps ( because I think those are the metrics of what oninit does on the physical cpus ).</div>
<div> </div>
<div>First question: Am I correct that only the cpuvps are directly tied to the physical cpus? Or do I n
 
 
 

how much cpu does Informix use

Post by Onin » Fri, 28 Mar 2008 22:52:54


Sounds like what you want is 'top'. You should be able to get an AIX
specific executable from IBM and IB that IBM also has an enhanced
version of top for AIX called 'topas' or download the generic UNIX top
source from sourceforge or www.unixtop.org.


That depends. If you are using a version before 9.40 (don't remember
your specs Floyd - sorry) that's certainly true, the AFF* parameters
only affect CPU VPs. In 9.40 and later if you are using VPCLASS to
specify VP settings (rather than the vp class specific parameters like
NUMAIOVPS) you can set affinity for any VP class that can be configured
using the VPCLASS parameter.


Yes.


Yes. That would be percent of available CPU if you add up all of the
CPU times for all VPs (or for given classes of VPs) and divide that by
the number of CPU Cores available to the instance time seconds since the
IDS instance was started that would give the percent of total CPU time
used. If you only multiply by the number of CPUs to which the VPs were
affined that would give the percentage of available assigned CPU time used.

Art S. Kagel
Oninit

 
 
 

how much cpu does Informix use

Post by Keith Simm » Fri, 28 Mar 2008 23:22:06


Floyd

topas is part of the AIX O/S and will give you some info, also nmon
(included in the O/S but recommended that you download the latest
version from IBM) is probably better as it gives the option of
capturing data over time and importing into a spreadsheet (excel).

Keith
 
 
 

how much cpu does Informix use

Post by Floyd Well » Fri, 28 Mar 2008 23:30:31

lt;div>Hey Art, Thanks for the reply. Please see my responses intermixed with yours.
<br>
<br>----- Original Message -----
<br>Subject: Re: how much cpu does Informix use
<br>Date: Thu, March 27, 2008 9:52
<br>From: "Art S. Kagel (Oninit)"
< XXXX@XXXXX.COM >
<br>Floyd Wellershaus wrote:
<br>> > IDS10 on AIX 5.3.
<br>> > Sorry if this has been asked before, but I still don't have a
<br>> > satisfactory answer.
<br>> > We are trying to determine exactly how much percentage of our system
<br>> > cpu, that Informix is using through time.
<br>> > This is proving to be a difficult task, because sar doesn't provide
<br>> > process names or id's so that I can correlate a percentage to 'oninit'.
<br>> > ps command doesn't provide percentage.
<br>>
<br>> Sounds like what you want is 'top'. You should be able to get an AIX
<br>> specific executable from IBM and IB that IBM also has an enhanced
<br>> version of top for AIX called 'topas' or download the generic UNIX top
<br>> source from sourceforge or <a href="http://www.unixtop.org">www.unixtop.org</a>. </div>
<div> </div>
<div><font color="#3333ff">We have topas, but I am unable to make it provide the information for all oninit processes. It seems to only care about the top 10 or so processes.</font>
<br>>
<br>> >
<br>> > I am thinking that at least I can use onstat -g glo, add up all of the
<br>> > total time for cpu vps ( because I think those are the metrics of what
<br>> > oninit does on the physical cpus ).
<br>> >
<br>> > First question: Am I correct that only the cpuvps are directly tied to
<br>> > the physical cpus? Or do I need to be counting all of the vps ?
<br>>
<br>> That depends. If you are using a version before 9.40 (don't remember
<br>> your specs Floyd - sorry) that's certainly true, the AFF* parameters
<br>> only affect CPU VPs. In 9.40 and later if you are using VPCLASS to
<br>> specify VP settings (rather than the vp class specific parameters like
<br>> NUMAIOVPS) you can set affinity for any VP class that can be configured
<br>> using the VPCLASS parameter.
<br>> </div>
<div> </div>
<div><font color="#3333ff">Not sure I get what you're saying. So we don't define VPCLASS, we just have NUMPAOVPS, NUMCPUVPS etc.... So does that mean we do count the aiovp stats when adding up the "physical" cpu time ? What about Soc, lio etc... , or just CPUVP'S ?</font>
<br>> >
<br>> > Second question. The numbers provided for each cpu is what ? Seconds ?
<br>>
<br>> Yes.
<br>>
<br>> > So, assuming that oninit has been up the entire time that the lpar has
<br>> > been up, if I divide the total time from onstat -g glo by the number
<br>> > of seconds since the lpar has been up, will that tell me the
<br>> > percentage of cpu that oninit uses ?
<br>>
<br>> Yes. That would be percent of available CPU if you add up all of the
<br>> CPU times fo
 
 
 

how much cpu does Informix use

Post by Floyd Well » Fri, 28 Mar 2008 23:35:24

hanks Keith,
That reminds me, I think I have hit youall up with this issue before. I
have been messing with a version of nmon, and am still unable to get it to
provide what I need. I'll take a look some more at it.





----- Original Message -----
Subject: Re: how much cpu does Informix use
Date: Thu, March 27, 2008 10:22
From: "Keith Simmons" < XXXX@XXXXX.COM >
On 27/03/2008, Art S. Kagel (Oninit) < XXXX@XXXXX.COM > wrote:
used.
 
 
 

how much cpu does Informix use

Post by Onin » Sat, 29 Mar 2008 00:41:30

loyd Wellershaus wrote:

It just means that the AIOVPS are not affined, they will float across
all CPUs unless you have done something external to IDS to restrict
their migration.


It means that the 2 CPU VPs together used approximately 25% of the
available CPU time equivalent to 50% of a single CPU.

Art S. Kagel
Oninit



 
 
 

how much cpu does Informix use

Post by Floyd Well » Sat, 29 Mar 2008 06:53:41

hank You !!



----- Original Message -----
Subject: Re: how much cpu does Informix use
Date: Thu, March 27, 2008 11:41
From: "Art S. Kagel (Oninit)" < XXXX@XXXXX.COM >
Floyd Wellershaus wrote:
 
 
 

how much cpu does Informix use

Post by Onin » Sat, 29 Mar 2008 07:45:21


[cutting]

[cutting]

Just complete some testing on HP and turning affinity off and letting
the OS sort it out when the server is running IDS and the application
gave better overall performance ie transaction throughput (64 CPU
machine, 48 CPUVPs, 36 application connection poolers)

Cheers
Paul


Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com

Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.