RE: Measuring CPU and I/O
Hi
What about:
1. Login as "userX"
2. Issue onstat -z to zero all your profile counters.
3. As userX, issue sql statement #1
4. Inspect the cpu time, #reads, #writes, etc using the relevant onstat
commands.
5. Repeat steps 2..4 for each remaining statement you wanna profile
Of course, this is a very manual process, but I don't know of any other
way to get to the level of detail you're after. I guess it it could be
automated
with a little work. Also, The use of onstat to get at the SMI info would not
be
appropriate if theie were other active sessions. If this was the case, maybe
you
could use oncockpit's Sessions view to drill down to the stats relevant for
UserX.
Be aware that onstat -x WILL zero your profile counters. So you
may not want to use this method at all if you're using you counters
for some other kind of analysis.
Also, you'll have to set WSTATS 1 in your onconfig to enable cpu time stats.
WSTATS is undocumented so use at your own risks blah blah blah.
Hope this helps
Thanks
Andrew
> ----------
> From: John Shepherd[SMTP:johnshepherd@iname.com]
> Reply To: John Shepherd
> Sent: Wednesday, May 12, 1999 4:44 AM
> To: informix-list@iiug.org
> Subject: Measuring CPU and I/O
>
> Greetings,
> I would like to assess the CPU and I/O "cost" - in milliseconds - of
> Informix SQL Inserts, Selects, etc under AIX.
> Does anyone know of an accurate way to do this ?
> Or am I stuck with calculating the penalty from vmstat/iostat ?
>
> Cheers
> John
>