Re: SAme Aps on 2 Servers, different performance, help!

In article <5chhg1$kje@netnews.csie.nctu.edu.tw>, ccliu <ccliu@maria2.cs ie.nctu.edu.tw> writes > > >Hi Net, > I have a very confusing situation regarding to performance for >two similar Database. > >Server 1: >HP-UX A.09.04 U 9000/887 >INFORMIX-OnLine Version 7.12.UC1X8 >768 MB memory <------------*** double the memory *** !!! > >Server 2: >HP-UX B.10.01 U 9000/829 <-----** HP-UX 10.01 is dodgy (see other postings in http://ww.dejanews.com/). >INFORMIX-OnLine Version 7.13.UC1 >384 MB memory > > >Both have the same APs running. But Server 1 is almost twice faster than >Server 2. > >Their onconfig.1 file is slightly different: > > >Server 1: >< NETTYPE ipcshm,1,50,CPU # Override sqlhosts nettype parameters >< NETTYPE soctcp,3,60,NET # Override sqlhosts nettype parameters >< BUFFERS 40000 # Maximum number of shared buffers >< NUMAIOVPS 8 # Number of IO vps twice as many AIOVPS - possibly may help to improve disk performenace. >< PHYSBUFF 32 # Physical log buffer size (Kbytes) >< LOGBUFF 32 # Logical log buffer size (Kbytes) >< LOGSMAX 200 # Maximum number of logical log files >< RA_PAGES # Number of pages to attempt to read ahead >< RA_THRESHOLD # Number of pages left before next group >< LTXHWM 40 # Long transaction high water mark percentage >< LTXEHWM 50 # Long transaction high water mark (exclusive) >< OFF_RECVRY_THREADS 10 # Default number of offline worker threads >< FILLFACTOR 90 # Fill factor for building indexes >< OPCACHEMAX 0 # Maximum optical cache size (Kbytes) > > > > >Server 2: >> NETTYPE ipcshm,1,30,CPU # Override sqlhosts nettype parameters >> NETTYPE soctcp,2,120,NET # Override sqlhosts nettype parameters >> BUFFERS 30000 # Maximum number of shared buffers >> NUMAIOVPS 3 # Number of IO vps >> PHYSBUFF 64 # Physical log buffer size (Kbytes) >> LOGBUFF 64 # Logical log buffer size (Kbytes)>> LOGSMAX 100 # Maximum number of logical log files >> RA_PAGES 4 # Number of pages to attempt to read ahead >> RA_THRESHOLD 2 # Number of pages left before next group >> LTXHWM 50 # Long transaction high water mark percentage >> LTXEHWM 60 # Long transaction high water mark (exclusive) >> OFF_RECVRY_THREADS 3 # Default number of offline worker threads >> FILLFACTOR 80 # Fill factor for building indexes>> OPCACHEMAX 128 # Maximum optical cache size (Kbytes) > > > I would need more info. I.e. what are the CPU's/disks on each machine. How are the disks partitions and what does tbstat -d say on each machine. How fast are the disks on each machine? Where is the rest of the onconfig files for each machine. > > >Can someone give me some advice??? >Thanks in advance. > > > >Scott > -- David Williams