Database Tuning

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C47E42.87698F80 Content-Type: text/plain Hi All, I recently started to experience slow response times on my informix based application suite. When I checked the database for the possibility of fragmentation, it was observed that most of major tables used just had one extent hence ruling out this cause. I ran one invocation of"onstat -p" to monitor the performance of my IDS Database ( Informix 7.31). Both my read and write cache returned values >99% as well as there was no indication of foreground writes. I did observes very large values for bufwrites ( 7867339), lockreqs ( 14404458417) , pagereads, bufreads etc etc.. I'm unsure how to interpret these high values. Can anyone shed some light into the reason for these high values witnessed. Will appreciate any advice on the above related matter.. thanks roger The information in this communication and any attachments are deemed by PPSL to be confidential and may be legally privileged and protected from disclosure. It is intended solely for the addressee. If you are not the intended recipient, any use, review, dissemination, distribution or copying of this information is strictly prohibited. Please notify the sender and delete this message and any attachments immediately from your system. PPSL will not be held liable for any incomplete transmission of this message nor any delay in its receipt. ------_=_NextPart_001_01C47E42.87698F80 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <TITLE>Message</TITLE> <META content=3D"MSHTML 6.00.2733.1800" name=3DGENERATOR></HEAD> <BODY style=3D"COLOR: #000000; FONT-FAMILY: Garamond" = hb_focus_attach=3D"true"> <DIV><SPAN class=3D267392718-07072004>Hi All,</SPAN></DIV> <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> <DIV><SPAN class=3D267392718-07072004>I recently started to experience = slow=20 response times on my informix based application suite. When I checked = the=20 database for the possibility of fragmentation, it was observed that = most of=20 major tables used just had one extent hence ruling out this cause. I = ran one=20 invocation of"onstat -p" to monitor the performance of my IDS Database = (=20 Informix 7.31).&nbsp;Both my read and write cache returned values = &gt;99% as=20 well as there was no indication of foreground writes. I did=20 observes&nbsp;very&nbsp;large values for bufwrites&nbsp;( 7867339), = lockreqs (=20 14404458417) , pagereads, bufreads etc etc..</SPAN></DIV> <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> <DIV><SPAN class=3D267392718-07072004>I'm unsure how to interpret these = high=20 values. Can anyone shed some light into the reason for these high = values=20 witnessed.</SPAN></DIV> <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> <DIV><SPAN class=3D267392718-07072004>Will appreciate any advice on the = above=20 related matter..</SPAN></DIV> <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> <DIV><SPAN class=3D267392718-07072004><SPAN = class=3D716005818-07072004><FONT=20 color=3D#0000ff><FONT color=3D#000000>&nbsp;thanks</FONT>=20 &nbsp;</FONT></SPAN></SPAN></DIV> <DIV><SPAN class=3D267392718-07072004>roger</SPAN></DIV> <DIV>&nbsp;</DIV> <P><B><I></I></B>&nbsp;</P> <P></P> <P></P></BODY></HTML> <BR> <BR> <P><B><FONT SIZE=3D2 FACE=3D"Arial">The information in this = communication and any attachments are deemed by PPSL to be confidential = and may be legally privileged and protected from disclosure. It is = intended solely for the addressee. If you are not the intended = recipient, any use, review, dissemination, distribution or copying of = this information is strictly prohibited. Please notify the sender and = delete this message and any attachments immediately from your = system.</FONT></B></P> <P><B><FONT SIZE=3D2 FACE=3D"Arial">PPSL will not be held liable for = any incomplete transmission of this message nor any delay in its = receipt.</FONT></B></P> <BR> <BR> ------_=_NextPart_001_01C47E42.87698F80-- sending to informix-list

Roger Cariah wrote: > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. Don't post frickin' MIME - Clowns hate MIMEs. UPDATE STATISTICS? > ------_=_NextPart_001_01C47E42.87698F80 > Content-Type: text/plain > > Hi All, > > I recently started to experience slow response times on my informix based > application suite. When I checked the database for the possibility of > fragmentation, it was observed that most of major tables used just had one > extent hence ruling out this cause. I ran one invocation of"onstat -p" to > monitor the performance of my IDS Database ( Informix 7.31). Both my read > and write cache returned values >99% as well as there was no indication of > foreground writes. I did observes very large values for bufwrites ( > 7867339), lockreqs ( 14404458417) , pagereads, bufreads etc etc.. > > I'm unsure how to interpret these high values. Can anyone shed some light > into the reason for these high values witnessed. > > Will appreciate any advice on the above related matter.. > > thanks > roger > > > > > > > The information in this communication and any attachments are deemed by > PPSL to be confidential and may be legally privileged and protected from > disclosure. It is intended solely for the addressee. If you are not the > intended recipient, any use, review, dissemination, distribution or > copying > of this information is strictly prohibited. Please notify the sender and > delete this message and any attachments immediately from your system. > PPSL will not be held liable for any incomplete transmission of this > message nor any delay in its receipt. > > > > ------_=_NextPart_001_01C47E42.87698F80 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Dus-ascii"> > <TITLE>Message</TITLE> > > <META content=3D"MSHTML 6.00.2733.1800" name=3DGENERATOR></HEAD> > <BODY style=3D"COLOR: #000000; FONT-FAMILY: Garamond" = > hb_focus_attach=3D"true"> > <DIV><SPAN class=3D267392718-07072004>Hi All,</SPAN></DIV> > <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> > <DIV><SPAN class=3D267392718-07072004>I recently started to experience = > slow=20 > response times on my informix based application suite. When I checked = > the=20 > database for the possibility of fragmentation, it was observed that = > most of=20 > major tables used just had one extent hence ruling out this cause. I = > ran one=20 > invocation of"onstat -p" to monitor the performance of my IDS Database = > (=20 > Informix 7.31).&nbsp;Both my read and write cache returned values = > &gt;99% as=20 > well as there was no indication of foreground writes. I did=20 > observes&nbsp;very&nbsp;large values for bufwrites&nbsp;( 7867339), = > lockreqs (=20 > 14404458417) , pagereads, bufreads etc etc..</SPAN></DIV> > <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> > <DIV><SPAN class=3D267392718-07072004>I'm unsure how to interpret these = > high=20 > values. Can anyone shed some light into the reason for these high = > values=20 > witnessed.</SPAN></DIV> > <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> > <DIV><SPAN class=3D267392718-07072004>Will appreciate any advice on the = > above=20 > related matter..</SPAN></DIV> > <DIV><SPAN class=3D267392718-07072004></SPAN>&nbsp;</DIV> > <DIV><SPAN class=3D267392718-07072004><SPAN = > class=3D716005818-07072004><FONT=20 > color=3D#0000ff><FONT color=3D#000000>&nbsp;thanks</FONT>=20 > &nbsp;</FONT></SPAN></SPAN></DIV> > <DIV><SPAN class=3D267392718-07072004>roger</SPAN></DIV> > <DIV>&nbsp;</DIV> > <P><B><I></I></B>&nbsp;</P> > <P></P> > <P></P></BODY></HTML> > <BR> > <BR> > > <P><B><FONT SIZE=3D2 FACE=3D"Arial">The information in this = > communication and any attachments are deemed by PPSL to be confidential = > and may be legally privileged and protected from disclosure. It is = > intended solely for the addressee. If you are not the intended = > recipient, any use, review, dissemination, distribution or copying of = > this information is strictly prohibited. Please notify the sender and = > delete this message and any attachments immediately from your = > system.</FONT></B></P> > > <P><B><FONT SIZE=3D2 FACE=3D"Arial">PPSL will not be held liable for = > any incomplete transmission of this message nor any delay in its = > receipt.</FONT></B></P> > <BR> > <BR> > > ------_=_NextPart_001_01C47E42.87698F80-- > sending to informix-list -- Strewth! Stick a sock in it, Sheila!