Re: Performance Monitoring/Tuning
Jeez, RAID5. Need I say more? :-(
Send us the output from the following commands:
onstat -c
onstat -p
onstat -P | tail -5
onstat -u | tail -2
onstat -d
onstat -D
onstat -g iov
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