Re: Performance Issues
From: "Kirk Davis" <kirk@kirkdavis.co.uk>
>
>As my earlier post, we have just upgraded our Informix Dynamic Server 7.3
>hardware to a 4 * 550mhz Xeon with 1024mb RAM.. The platform was previously
>a single 200mhz
>Pentium wth 256mb RAM.
>
>As suggested, I have set the following to optimise performance:
>
>NUMCPUVPS 3
>MULTIPROCESSOR 1
>SINGLE_CPU_VP 0>
>As well as UPDATE STATISTICS, and increase the buffers to 2000, but the
>system does not seem to be running much faster than before, and I have run
>out of ideas.
2000 Buffers? You're joking, right? How much RAM have you got? 1GB? And
you're generously donating 4MB to the database???
Please send the output from:
onstat -
onstat -c
onstat -m
onstat -p
onstat -P | tail -5
onstat -u | tail -2
onstat -R
onstat -F
onstat -d
onstat -D
onstat -g iov
onstat -g athsar 5 12
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com