Re: IDS/BaaN performance issues

It's my expirience that to get the CPU VPs running on different physical cpus on HPUX, you must set AFF_SPROC and AFF_NPROCS in $ONCONFIG so when you have a 4 cpu machine and want to run 3 CPU VPs, this would do: AFF_SPROC 1 # Affinity start processor AFF_NPROCS 3 # Affinity number of processors and more onstat -p shows 421160 Kb memory allocatedif you are only running IDS on this machine, I would double BUFFERS are you using your disks usage optimal ? you should run onstat -g iof and iostat or sar to study io regards Claus Samuelsen russ_kahler@andersonsinc.com wrote: > Greetings, > > We are running IDS version 7.30.uc5 on a 4-way HP 9000 K-250 with 2.25 > GB of memory, and HP-UX 10.20. We are also a BaaN installation running > b40c4 with about 20 production users, and 25 test users. > > We have been experiencing performance difficulties with BaaN, and I have > modified our onconfig to try to adjust for this. I recently added memory > to bring it up to 2.25 GB, and also adjusted the SHMVIRTSIZE,BUFFERS,and > CLEANERS to try and make better use of the added memory. What I saw > however in onstat -p was a decline in both read cache % and write cache > %. Are buffers still an issue here? > > Also, where I do an onstat -g glo, it seems as if the virtual processors > are not balancing the loads between them, as one processor seems to be > doing 2X the work of the other two. I am able to confirm this by running > glance- as the oninit processes are using only 20 -40% of the CPU, while > the rest sit idle. Informix technical support says this is normal, but > that just doesn't seem right. > > Thanks for any help you can give. Here is the info: > > onstat -p :> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 14:20:53 -- > 421160 K > bytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 7536503 12194535 78503378 90.40 111959 163941 661937 83.09 > > isamtot open start read write rewrite delete commit > rollbk > 36612289 443031 1916363 29251116 68550 113615 19749 51768 > 0 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 6499.98 1867.23 69 344 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 526588 0 30721288 0 0 15 8138 13609 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 4436892 11 1311 4423770 3720 > > onstat -g glo> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 14:22:21 -- > 421160 K > bytes > > MT global info: > sessions threads vps lngspins > 62 95 10 0 > > sched calls thread switches yield 0 yield n yield > forever > total: 30482118 28283418 2493985 135177 13918422 > per sec: 0 0 0 0 0 > > Virtual processor summary: > class vps usercpu syscpu total > cpu 3 6612.03 1857.59 8469.62 > aio 3 2.15 7.43 9.58 > lio 1 0.76 2.22 2.98 > pio 1 0.71 2.48 3.19 > adm 1 4.06 9.73 13.79 > msc 1 1.58 0.50 2.08 > total 10 6621.29 1879.95 8501.24 > > Individual virtual processors: > vp pid class usercpu syscpu total > 1 2511 cpu 1023.73 410.28 1434.01 > 2 2512 adm 4.06 9.73 13.79 > 3 2513 cpu 3803.59 1070.54 4874.13 > 4 2514 cpu 1784.71 376.77 2161.48 > 5 2515 lio 0.76 2.22 2.98 > 6 2516 pio 0.71 2.48 3.19 > 7 2517 aio 0.79 2.68 3.47 > 8 2518 msc 1.58 0.50 2.08 > 9 2519 aio 0.69 2.57 3.26 > 10 2520 aio 0.67 2.18 2.85 > tot 6621.29 1879.95 8501.24 > > onconfig file > > # Root Dbspace Configuration > > ROOTNAME rootdbs # Root dbspace name> ROOTPATH /dev/informix/baan/rootdbs > # Path for device containing root > dbspace > ROOTOFFSET 0 # Offset of root dbspace into device > (Kbytes) > ROOTSIZE 500000 # Size of root dbspace (Kbytes)> > # Disk Mirroring Configuration Parameters > > MIRROR 0 # Mirroring flag (Yes = 1, No = 0) > MIRRORPATH # Path for device containing mirrored> root > MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> > # Physical Log Configuration > > PHYSDBS rootdbs # Location (dbspace) of physical log > PHYSFILE 200000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 30 # Number of logical log files > LOGSIZE 1000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /informix/logs/online_prod.log # System message log file > path > CONSOLE /informix/logs/console_prod.log # System console message > path > ALARMPROGRAM /informix/etc/no_log.sh # Alarm program path > #ALARMPROGRAM /informix/etc/log_full.sh # Alarm program path > > # System Archive Tape Device > > TAPEDEV /dev/rmt/3m # Tape device path > TAPEBLK 2048 # Tape block size (Kbytes) > TAPESIZE 20000000 # Maximum amount of data to put on tape > (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /dev/rmt/1m # Log tape device path> #LTAPEDEV /dev/null # Log tape device path > LTAPEBLK 2048 # Log tape block size (Kbytes) > LTAPESIZE 4000000 # Max amount of data to put on log tape > (Kbytes)> > # Optical > > STAGEBLOB # INFORMIX-OnLine/Optical staging area > > # System Configuration > > SERVERNUM 1 # Unique id corresponding to a OnLine> instance > DBSERVERNAME baan # Name of default database server > DBSERVERALIASES # List of alternate dbservernames > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> distributed env. > RESIDENT 1 # Forced residency flag (Yes = 1, No = > 0) > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor > NUMCPUVPS 3 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> to one > > NOAGE 1 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> >