SAme Aps on 2 Servers, different performance, help!
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