Re: Informix SQL Performance tool needed.

tedw@mcs.com (Ted Whittington) wrote: >I just inherited an Informix DBA position, and I am looking forward to >it. But if you have any suggestions, I need a little help. > >The system I interited is having performance problems. It uses what I >perceive to be complex stored procedures (I am new to informix), runs >on AIX 3.2.5. I am not sure of the machine version, but I suspect it >to be an RS6000-560. > >Specifically we need to be able to guage the resource per SQL >statement, to try to find bottlenecks, and determine how much more >machine, memory, buffers, etc to throw at it. Although it will Can't give you what you asked for, but I will provide this warning: don't assume that the SQL statements and the logic around them are optimal. Often poor performance can be easily solved by rewriting queries, slightly changing the algorithms which make use of SQL, or providing needed indexes. As you can tell, I tend to use "throwing more resources at it" as a last resort to improving performance. -- John Hess Software Engineer Aeronomics Incorporated John_Hess@Aeronomics.com Atlanta, GA