Re: Informix SQL Performance tool needed.

John Hess <John_Hess@Aeronomics.com> wrote: >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 I would also add to John's comments, that database layout is also very important.. Try and determine which tables are the most active, if there is contention between tables is dbs or on a disk drive.. Also check lock modes (page/row) if your rows are small and lock mode is page you will have performance problems.. Also make sure that your most active tables have not extented, this can impact performance greatly in informix. Hope this helps