Re: Poor Informix performance
"Paul Watson" <paul@oninit.com> wrote in message
news:406D10C0.4305B997@oninit.com...
> You don't mention the OS, the informix version or anything about the
> server. But ...
>
> you appear to be using cooked files
> you say there are 400 users but you've configure for 200 at startup
> there are no temp dbspaces configured
> what is ccm_aci
>
> Fire out your
> onstat -R,
> onstat -p,
> onstat -F,
> onstat -m,
> onstat -l>
onstat -u ...what are the sessions with the largest reads/writes doing...
> Viji wrote:
> >
> > Hi,
> >
> > We have a database, a rather huge one, with about 10G of
> > metadata...and almost 400 users...
> > We have serious performance problems over the past few mnths....and
> > all sorts of tuning etc...didnt seem to help much..
> > The System Admins claim that nothing is wrong with the network and its
> > all the database's fault...Sometimes, the users are just waiting and
> > waiting till a query returns..
> > Running 'top' on the system gives this O/P
> >
> > load averages: 3.42, 3.49, 3.56
> > 16:33:39
> [cutting]
>
> --
> Paul Watson #
> Oninit Ltd # Growing old is mandatory
> Tel: +44 1436 672201 # Growing up is optional
> Fax: +44 1436 678693 #
> Mob: +44 7818 003457 #
> www.oninit.com #