Re: query performance tools

tomL said: > hello all, > > we are in dire need of optimizing sql for our system. Are there > techniques or (ESPECIALLY!) tools we can use that will monitor sql > sent and report on the worst performing sql utilized in our system? > > We are on informix 9.40 FC3 on hp-UX 11i I can be hired for a reasonable sum. I've been told quite often that I'm a tool. Oh, sorry. "Fool". Apparently I'm a fool. Is that the same thing? Have you considered onstat -g sql? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "Necrophilia means never having to say ... well, anything!" - Captain Pedantic "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco sending to informix-list

"Obnoxio The Clown" <obnoxio@serendipita.com> wrote: > > tomL said: > > hello all, > > > > we are in dire need of optimizing sql for our system. Are there > > techniques or (ESPECIALLY!) tools we can use that will monitor sql > > sent and report on the worst performing sql utilized in our system? > > > > We are on informix 9.40 FC3 on hp-UX 11i > > I can be hired for a reasonable sum. I've been told quite often that I'm a > tool. > > Oh, sorry. "Fool". Apparently I'm a fool. Is that the same thing? Not exactly. But if I had to pick one... :-) > Have you considered onstat -g sql? You must have missed the "onstat -g sql in 9.4" thread while you were catching up, or maybe you haven't gotten to it yet. There is a bit of a problem there that should be corrected with 9.40.UC5, with a fix available for UC4. Haven't seen any information on the 9.40.FCx set. I do know that 9.40.FC2 has the problem... on AIX 5.2.0.0 - in case that makes a difference. (It might - Paul Watson said it was fine with 9.40.UC3 on Solaris 7.) In any case, that command on 9.40.FC3, hp-UX 11i may not give the information that you were suggesting. [P.S. Thanks for the giggle. It has been rather, um, dry here without you.] -- June Hunt

June C. Hunt wrote: > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote: > > [P.S. Thanks for the giggle. It has been rather, um, dry here without > you.] That, IMHO is the understatement of the week, at least.