Re: Measuring CPU and I/O

The Zero Impact Sql Monitor will measure every SQL statement's end-user response time, database server response time, rows returned and errors. Also will capture SQL text, login id, server and client IP addresses, connect times, network send and receive time, etc. Product will automatically alert you to long running SQL transactions by elapsed time, rows returned, login id, keywords in SQL text and more. The SQL transaction flow sent to the database server from any prior time period can be reconstructed. Requires no connection to the database server, intrusive middleware, database audits, probes or traces. The Zero Impact Service Level Monitor will monitor end-user and database server SQL transaction service levels. Product automatically alerts you to monitoring intervals with poor database performance or long end-user response times. The SQL transaction flow sent to the database server from any service level interval can be reconstructed. Installation is a few minutes. Refer to www.sqlpower.com John Shepherd wrote in message <37387AA6.8A5E997C@iname.com>... >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 >