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

Hi, Looking at the memory of the 2 machines I'm not surprised at the better performance on Server 1. You also have several other configuration differences between the two machines. The NUMAIOVPS is 8 on server 1 and 3 on Server 2. Is this because you have more disks allocated to Online on Server 1? It also appears that you are suing more CPU's on Server 1. Look at your NETTYPE settings. Also, BUFFERS are not equal, this is probably because of the memory differences of the machines. Bottom line is: You need to compare apple to apples. These machines don't appear to be equipped/configured equally. -Bill } } } } 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 } } Server 2: } HP-UX B.10.01 U 9000/829 } 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 } < 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) } } } } } } Can someone give me some advice??? } Thanks in advance. } } } } Scott } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com