Re: (2) Performance Monitoring/Tuning

Also: UPDATE STATISTICS From: Thomas Stainer <tstainer@styria.com> > >As the users of our advertisement system are moaning about the bad >performance, i'm trying to find out why the system's perfomance isn't as >good as it was in the beginning. Even after dropping and reimporting the >whole database the performance was only slightly better. I'm running >informix 7.30 UC6 on hp-ux 10.20, the rootdbs is located on the system's >root-hd, the aps-dbspaces are lying in an AutoRaid (Raid5) striped over >8 discs - therefor fragmentation of the big tables won't better the >performance (or am i wrong)?. >Does a change of LRU_MAX_DIRTY/LRU_MIN_DIRTY (actually 50/60) improve >performance? >The server isn't only db-server but also application server, how many of >the (4) CPUs should by affinated? >I somewhere read, the number of LRUs should equal the number of CPUs of >the db-server - is this right? >How can I generally monitor system's performance/throughput? >Furthermore the workload of the lun the dbspace are located on often >averages some 80 - 90 p.c. - may be this a reason for the bad >performance? > >thanx for help > >thomas >------------------------------------------------- >Thomas Stainer - tstainer@styria.com > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com