RE: system configuration

The first obvious issue is the number of sequential scans!! Have you run UPDATE STATISTICS as described in your release notes? It is most important to run regularly. You do not appear to have sufficient locks allocated (you ran out) and have contention of resources (latch waits). Looks like your instance is not tuned - take a tuning course or get someone with experience to assist tuning. Murray Wood -----Original Message----- From: the_griffon@my-deja.com [SMTP:the_griffon@my-deja.com] Sent: Tuesday, November 16, 1999 10:21 AM To: informix-list@iiug.org Subject: system configuration I have a dilemma. we are runnig informix IDS on a Sun E3000 with 6 200Mhz processors and 1 gig of ram. our performance is very poor. We have spent most of the last year tweaking the engine but our traffic increases and performance remains poor. We are now looking to upgrade our server and are at a loss for what sort of horsepowere we shuld be shopping for. I am attaching the end of day stats for one of our busiest days over the summer at the bottom of this post and would appreciate it if someone could give me some idea what sort of system we should be shopping for. I was thinking a Sun 6000 or 6500. I look forward to any input. If you would like more info please let me know. email address is mhdevlin@nycap.rr.com or mdevlin@reserveamerica.com. thanks again. INFORMIX-OnLine Version 7.24.UC6 -- On-Line -- Up 21:38:49 -- 304512 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 14772607 18002755 2254304397 99.34 1891087 2680138 8456961 77.64 isamtot open start read write rewrite delete commit rollbk 1409519981 10520849 19769422 844321135 2142142 674864 149469 477957 14583 2 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 837 0 0 104601.92 10303.19 183 366 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 1211977 71635 1968591814 12 0 3994 99375 501393 ixda-RA idx-RA da-RA RA-pgsused lchwaits 3016390 500803 9831594 13137760 9555401 Sent via Deja.com http://www.deja.com/ Before you buy.

In article <80qd12$ghr$1@news.xmission.com>, Murray Wood <murray@quanta.co.nz> writes > >The first obvious issue is the number of sequential scans!! > This might not be a problem. Out application has 1 table with 1 row which is a site id using a lookup configuration data. Every time a configurable option in our product is access this table is sequentially scanned. Any reference data table with <100 rows may well be sequentially scanned many times. The number of buff reads however seems to indicate indexes and not being used. What does onstat -u show, many reads per user, how many maximum concurrent users?? >Have you run UPDATE STATISTICS as described in your release notes? It is most >important to run regularly. >You do not appear to have sufficient locks allocated (you ran out) and have >contention of resources (latch waits). > >Looks like your instance is not tuned - take a tuning course or get someone with >experience to assist tuning. > >Murray Wood > > >-----Original Message----- >From: the_griffon@my-deja.com [SMTP:the_griffon@my-deja.com] >Sent: Tuesday, November 16, 1999 10:21 AM >To: informix-list@iiug.org >Subject: system configuration > >I have a dilemma. we are runnig informix IDS on a Sun E3000 >with 6 200Mhz processors and 1 gig of ram. our performance is very >poor. We have spent most of the last year tweaking the engine but our >traffic increases and performance remains poor. We are now looking to >upgrade our server and are at a loss for what sort of horsepowere we >shuld be shopping for. I am attaching the end of day stats for one of >our busiest days over the summer at the bottom of this post and would >appreciate it if someone could give me some idea what sort of system we >should be shopping for. I was thinking a Sun 6000 or 6500. I look >forward to any input. If you would like more info please let me know. >email address is mhdevlin@nycap.rr.com or mdevlin@reserveamerica.com. >thanks again. > >INFORMIX-OnLine Version 7.24.UC6 -- On-Line -- Up 21:38:49 -- 304512 >Kbytes > >Profile >dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >14772607 18002755 2254304397 99.34 1891087 2680138 8456961 77.64 > >isamtot open start read write rewrite delete commit >rollbk >1409519981 10520849 19769422 844321135 2142142 674864 149469 >477957 14583 >2 > >ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes >837 0 0 104601.92 10303.19 183 366 > >bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans >1211977 71635 1968591814 12 0 3994 99375 501393 > >ixda-RA idx-RA da-RA RA-pgsused lchwaits >3016390 500803 9831594 13137760 9555401 > > >Sent via Deja.com http://www.deja.com/ >Before you buy. > -- David Williams

Actually, we have been thru our configs line by line with informix. Also statistics are updated nightly. We currently have 100000 locks configured in this instance. The applications that access this system range from informix 4gl, java, web processes (mostly written in java) We process online reservations with as many as 800 simultaneous connections. I agree that there are a large number of sequential scans. That is an unfortunate side effect of the reservation programs. Many times the agents or web customers do not use the most effecient methods for quering our inventory table which is currently Over 19 million rows. (this is something that is being addressed by the developers) So far no one has offered the advice I have been seeking. I am not really interested in software issues regarding this post as I am well aware of certain configuration issues. What I am looking for as some input from other users out there regarding the type of machine we should be looking into. Our next big step is going to be a major system upgrade and I want to be sure that we don't underbuy. In article <80qd12$ghr$1@news.xmission.com>, "murray@quanta.co.nz" <murray@quanta.co.nz> wrote: > > The first obvious issue is the number of sequential scans!! > > Have you run UPDATE STATISTICS as described in your release notes? It is most important to run regularly. > You do not appear to have sufficient locks allocated (you ran out) and have contention of resources (latch waits). > > Looks like your instance is not tuned - take a tuning course or get someone with experience to assist tuning. > > Murray Wood > > -----Original Message----- > From: the_griffon@my-deja.com [SMTP:the_griffon@my-deja.com] > Sent: Tuesday, November 16, 1999 10:21 AM > To: informix-list@iiug.org > Subject: system configuration > > I have a dilemma. we are runnig informix IDS on a Sun E3000 > with 6 200Mhz processors and 1 gig of ram. our performance is very > poor. We have spent most of the last year tweaking the engine but our > traffic increases and performance remains poor. We are now looking to > upgrade our server and are at a loss for what sort of horsepowere we > shuld be shopping for. I am attaching the end of day stats for one of > our busiest days over the summer at the bottom of this post and would > appreciate it if someone could give me some idea what sort of system we > should be shopping for. I was thinking a Sun 6000 or 6500. I look > forward to any input. If you would like more info please let me know. > email address is mhdevlin@nycap.rr.com or mdevlin@reserveamerica.com. > thanks again. > > INFORMIX-OnLine Version 7.24.UC6 -- On-Line -- Up 21:38:49 -- 304512 > Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 14772607 18002755 2254304397 99.34 1891087 2680138 8456961 77.64 > > isamtot open start read write rewrite delete commit > rollbk > 1409519981 10520849 19769422 844321135 2142142 674864 149469 > 477957 14583 > 2 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 837 0 0 104601.92 10303.19 183 366 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 1211977 71635 1968591814 12 0 3994 99375 501393 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 3016390 500803 9831594 13137760 9555401 > > Sent via Deja.com http://www.deja.com/ > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.