FW: Performance dive over time

Be careful when using NOAGE. You will have to benchmark this on your system to see which is better. In our case our system slowed down alot by actually using NOAGE. We are now running without it. Dirk Reach Technologies dirkm@reach.co.za -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Barry Lloyd Sent: Thursday, November 09, 2000 8:32 PM To: informix-list@iiug.org Subject: Re: Performance dive over time NOAGE in onconfig? ktroxel@my-deja.com wrote: > > Hi - > I've got an instance of IDS (7.31.UC4) running on Sun E4000/Solaris > 2.6. Average 320 users, 18 Gig of space. Mostly OLTP w/some > statistical reports run on occasion. > > Over time, the performance of Informix takes a dive. It seems to > degrade a little every day until it becomes unacceptable. I bounce the > engine (about once a month now) and everything gets better, until over > time I have to do it again. > > Am I missing something obvious here? Any clue would be great help. > > TIA > > Sent via Deja.com http://www.deja.com/ > Before you buy.

?? So starving Online of CPU time helps? Sounds like you have too many CPU VPS configured or something wierd is happening.. What platform/Online version? onstat -c output? David. Dirk Moolman wrote in message <8ugaq8$shv$1@news.xmission.com>... > >Be careful when using NOAGE. You will have to benchmark this on your system >to see which is better. >In our case our system slowed down alot by actually using NOAGE. We are now >running without it. > > >Dirk >Reach Technologies >dirkm@reach.co.za > > >-----Original Message----- >From: owner-informix-list@iiug.iiug.org >[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Barry Lloyd >Sent: Thursday, November 09, 2000 8:32 PM >To: informix-list@iiug.org >Subject: Re: Performance dive over time > > >NOAGE in onconfig?> >ktroxel@my-deja.com wrote: >> >> Hi - >> I've got an instance of IDS (7.31.UC4) running on Sun E4000/Solaris >> 2.6. Average 320 users, 18 Gig of space. Mostly OLTP w/some >> statistical reports run on occasion. >> >> Over time, the performance of Informix takes a dive. It seems to >> degrade a little every day until it becomes unacceptable. I bounce the >> engine (about once a month now) and everything gets better, until over >> time I have to do it again. >> >> Am I missing something obvious here? Any clue would be great help. >> >> TIA >> >> Sent via Deja.com http://www.deja.com/ >> Before you buy. >