RE: Off and On Informix Performance Issues
BUFFERS 1000 ? You are running informix in 4Mb. How much memory do you have
on the server?
LRU_MAX_DIRTY LRU_MIN_DIRTY should be something like 4/2.
Windows version and what service packs?
What informix version - complete TC???
What becomes slow? How long does the slowness take to clear?
What does windows monitors say when the system is slow?
Post the following for a start ....
onstat -p
onstat -d
onstat -m
onstat -g seg
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Gary Aders
> Sent: Wednesday, 11 June 2003 6:38 a.m.
> To: informix-list@iiug.org
> Subject: Re: Off and On Informix Performance Issues
>
>
> gaders@masterbrandcabinets.com (Gary Aders) wrote in message
> news:<4a5a9f2f.0306100611.83d1fcf@posting.google.com>...
> > We have experienced Informix Performance issues where for no reason
> > that we can determine, the Informix database slows down.
> We have run
> > a Sniffer product to determine that they are no network issues. In
> > fact all other applications are working fine in terms of response
> > time. The server Performance monitor shows that the server does not
> > seem to have any bottlenecks and the Informix database is the only
> > application on this server. The best part is that after a couple of
> > days of hair pulling, the performance issue disappears only to
> > reappear in the following months. At this point in time, we are
> > looking at our connection client which I am told is Inet.
> Does anyone
> > have any knowledge of how to improve Inet? Due to the economy, our
> > best Informix person is no longer with the company and I have had no
> > formal training so I am sorry if my message is a little incoherent.
> [cut]