Re: how much cpu does Informix use

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 >

Art S. Kagel (Oninit) wrote: > Floyd Wellershaus wrote: [cutting] >> >> 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. > [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.