what are all the statistics i should collect for cpu perf

Posted in 2006

Topics: Performance & Tuning, Platform-Specific Issues

madh — 2 Nov 2006 02:29:58 -0800 — source: Usenet: comp.databases.informix

Hi I am using .informix 7.33 on HP-ux 11.x what are all the things i have to do monitor the perf. for cpu utilization. now numcpuvps is 2. i plan it to increase it to 4. which part of the stats i have to see to for the improvement in performance. thanks in adv. madu

↪ replying to madh

Superboer — 2 Nov 2006 05:28:54 -0800 — source: Usenet: comp.databases.informix

how many cpu's do you have??? > which part of the stats i have to see to for the improvement in > performance. if # of cpus = 2 then do not change. qry/transaction responce time i guess... obtain stats using sar.... iostat.. look at how many logs/hr are produced; dono it depends on your system. Superboer. madh schreef: > Hi > > I am using .informix 7.33 on HP-ux 11.x > > what are all the things i have to do monitor the perf. for cpu > utilization. > > now numcpuvps is 2. > > i plan it to increase it to 4. > > which part of the stats i have to see to for the improvement in > performance. > > thanks in adv. > madu