Re: KEY PERFORMANCE METRICS

onstat -g iof will give you IO/sec average per chunk file. The total IO/secfor all chunks is more difficult. It will be somewhere between the average of those averages and the total of all of them. Transactions per second you will be better off getting from your applications. Onstat -p does reports the number of COMMITs which represents successful transactions, however, you have no way to know the frequency. You could run a cron to do onstat -p appending to a file followed by an onstat -z (to clear the stats to zeros) every hour or every 15 minutes to see your periodic transaction rates and extrapolate the peak load transactions per second from those files. CPU usage is reported on the onstat -g glo report by CPU VP (so per oninit process) and in onstat -g cpu reports cpu usage be thread which you can trace back to individual sessions or applications. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Oct 29, 2010 at 3:32 PM, Omar Muñoz <omarmun@yahoo.com> wrote: > Hi there, > > Since we are evaluating to update our current server, our HW providers > ask us > to send them number or transactions per second, io per second and cpu used > by > informix. I see there are a lot of metrics sent by onstat, but I want to > ask you > for your advice about which onstat commands are adequate to evaluate those > metrics. > > Thanks in advance > > Omar Muñoz > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >