Re: Performance Problem

From: chivaviro1379@my-deja.com > >I have the configuration below running on HP-UX B.11.00 U 9000/800.on >L100 class which is 64bit machine. >I have run update statistics but nothing significantly has improved. >Also my backup takes long. Checkpoints are as low as 8 seconds and I >have more than 200 users working on line. What changes would you >recommend that I should do to this configuration to improve speed. >users are now on my neck. As *Low* as 8 seconds? >Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 1 days >06:50:31 -- 747528 Kbytes > >Configuration File: /u/informix/etc/onconfig.live ># Root Dbspace Configuration > >ROOTNAME rootdbs # Root dbspace name >ROOTPATH /dev/rootdbs # Path for device containing root I don't like my informix devices in /dev, personally. ># Physical Log Configuration > >PHYSDBS rootdbs # Location (dbspace) of physical log Move your logical and physical logs to their own dbspaces on separate drives. >TBLSPACE_STATS 1 Set this to 0. >NETTYPE ipcshm,1,500,CPU # Configure poll thread(s) for nettype Are your users connecting via TCP or SHM? This looks a bit high -- try 200 rather than 500. >NETTYPE soctcp,1,5,NET # Configure poll thread(s) forAnd this is just silly: try 200 instead of 5. >RESIDENT 0 # Forced residency flag (Yes = 1, No Try -1. >MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi->processor >NUMCPUVPS 2 # Number of user (cpu) vps >SINGLE_CPU_VP 0 # If non-zero, limit number of cpu This is a mess. If you have more than one CPU, use: MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi- NUMCPUVPS 2 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu If you have only one CPU, use: MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi- NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu >LOCKS 400000 # Maximum number of locks >BUFFERS 200000 # Maximum number of shared buffers These can be juggled with, but seem reasonable enough. What does onstat -p say? >NUMAIOVPS 8 # Number of IO vps Is KAIO on? Check your release notes for details. >PHYSBUFF 128 # Physical log buffer size (Kbytes) >LOGBUFF 128 # Logical log buffer size (Kbytes) What does onstat -l say? >CLEANERS 52 # Number of buffer cleaner processes Hmmm.....we'll revisit this. >SHMVIRTSIZE 300000 # initial virtual shared memory That's pretty big. How much RAM have you got? Sure you're not swapping? >CKPTINTVL 600 # Check point interval (in sec) Try 300. >LRUS 52 # Number of LRU queues Hmmm.....we'll revisit this. ># Read Ahead Variables >RA_PAGES # Number of pages to attempt to read>ahead >RA_THRESHOLD # Number of pages left before next group >DBSPACETEMP tempdbs # Default temp dbspaces You should really have at least 3, preferably on separate spindles. >MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority >DS_MAX_QUERIES 4 # Maximum number of decision support>queries >DS_TOTAL_MEMORY 512 # Decision support memory (Kbytes) >DS_MAX_SCANS 1048576 # Maximum number of decision support>scans >DATASKIP off # List of dbspaces to skip You don't have PDQPRIORITY set, do you? Because on an OLTP system, you'd be gating like mad. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com