Re: ONLINE SLOW on HP-9000!

Hi... some op system things to look at...check share mem parms in the kernel: semmni semmns ...also make sure the u are useing the template for big system...ie the kernel may still be in singel user mode ...do a sar 1 10 and post data... do a swapinfo and make sure u have ram listed ...ref chap 6 page 11 of hp-ux system admin tasks... i will post more later....jb. In article <UNNg$GAtrHB1Ew26@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: > In article <6e19r5$ivv$1@news.xmission.com>, Tim Kelly <Tkelly@svhs.org> > writes >> >>I'm running the same type of platform and number of users. I increased >>the memory to 128mb and it doesn't solve the problem. I'm also in a >>situation that I have several machines, so I loaded one with HP-UX 9.04 >>and Informix 5.x. This machine only has 64mb of memory, and it is >>faster than the 10.2 and 7.x Informix. >> > Run your SQL with set explain on and make sure that the relevant > indexes are being used. > >>I called Tech support, but they wanted money to do an analysis for >>performance. They however suggested running "Update statistics high for >>table", which I did. This did help. But, the 9.04 machine still >>'kicks-butt'. >> >>I too have played with the onconfig file, turning on/off KAIO and >>increasing buffers, etc. But, none of them seem to make a difference, >>at least one that is noticeable. The 10.2 and 7.2x just seems to be a >>'slug', but I'm still working on it hoping I stumble into something that >>makes a difference. I'm also looking into 10.x patches, in the hopes >>there may be some relieve. >> >> >> -----Original Message----- >> From: leekb@post1.com >> Sent: Monday, March 09, 1998 4:05 AM >> To: informix-list@iiug.org >> Subject: Re: ONLINE SLOW on HP-9000! >> >> In article <6dl744$g1u$1@news.xmission.com>, >>webster@bom-co.in.DHL.COM >> says... >> > >> > >From : x>carlson1@bellsouth.net >> > To : informix-list@iiug.org >> > Subject : Re: ONLINE SLOW on HP-9000! >> > Date : 05/03/98 04:05 >> > >> > >> > Cecilio wrote: >> > > >> > > Hi! >> > > I'm working with: >> > > - HP-9000 817, 64MB RAM, HP-UX 10.20 >> > > - Informix ONLINE 7.14 >> > > - 4GL RDS Application >> > > - My Database has 200 tables, but only 3 or 4 of them >>containing more >> > > than 100,000 rows. >> > > - 16 simultaneous users. >> > > >> > > I think it would work well, but the performance is LOW!!! >> > > I've tested different changes in the ONCONFIG file without >>good results. >> > > I don't know which is the problem: >> > > - Incorrect HP-UX configuration ? >> > > - Little memory? (I don't think so) >> > > - Incorrect ONCONFIG configuration ? >> > >> > Well I think you are facing this problem because the memory of >>your machine >> > is less. On an average HP-UX O/S 10.20 uses about 18-20MB >>of RAM. Also >> > if Informix is running on the machine, each user is assigned >>about 3MB of >> > RAM. And as you say that you have 16 simultaneous users >>working on the >> > machine which totals to 20 MB+(3Mb*16users) = 68MB. Also for >>process that >> > are initiated in the background memory is used. >> > >> > > >> > > Which are the main things about performance? >> > > >> > > Someone can help me? >> > > >> > > Thanks. >> > >> > Webster D'Souza >> > >> >> You should follow a series of steps in tackling such performance >>problem. >> What you should do FIRST is pin-pointing the bottleneck. Is it >>CPU, >> memory, or I/O? In most cases, CPU is unlikely. So look out for >>memory >> and I/O. Nail down the culprit and act accordingly. >> >> Good luck! >> >> LeeKB > -- trog48 <jbennett> trog48@primenet.com