Re: how much cpu does Informix use

On 27/03/2008, Art S. Kagel (Oninit) <art@oninit.com> wrote: > Floyd Wellershaus wrote: > > 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. > > 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. > > > > > 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 ? > > 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. > > > > > Second question. The numbers provided for each cpu is what ? Seconds ? > > Yes. > > > 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 ? > > 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. > > > > > Thanks for any advice on this. > > > > Floyd > Art S. Kagel > Oninit > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > 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