What's in Command Usage Reports?
Types of Reports
357
s
Average Rows/Response
Average number of rows in the passed and failed
responses. Derived by dividing the number of rows received by the number of
passed and failed responses.
s
Average Think Time
Average think time in seconds for
sqlexec
and
sqlprepare
statements only.
s
SQL Execution Commands
Number of
sqlexec
commands reported.
s
Preparation Commands
Number of
sqlprepare
commands reported.
s
Rows Processed
Number of rows processed by all reported
sqlexec
commands.
s
Processed Rows/Sec
Average number of rows processed per second. Derived by
dividing the number of rows processed by the active time.
s
Avg Rows/Execute Cmd
Average number of rows processed by each
sqlexec
command. Derived by dividing the number of rows processed by the number of
sqlexec
commands reported.
s
Avg Row Process Time
Average time in milliseconds for processing a row by an
sqlexec
command. Derived by dividing the time spent on
sqlexec
commands
by the number of rows processed.
s
Avg Execution Time
Average time in milliseconds to execute an
sqlexec
or
DCOM method call command. Derived by dividing the time spent on
sqlexec
commands by the number of
sqlexec
commands.
s
Avg Preparation Time
Average time in milliseconds to execute an
sqlprepare
command. Derived by dividing the time spent on
sqlprepare
commands by the
number of
sqlprepare
commands.
If any HTTP emulation commands are executed that access a Web server, the
Command Usage report includes:
s
Passed HTTP Connections
Number of successful HTTP connections established
by all reported
http_request
commands.
s
Failed HTTP Connections
Number of HTTP connection attempts that failed to
establish a connection for all reported
http_request
commands.
s
HTTP Sent Kbytes
Kilobytes of data sent by reported
http_request
commands.
s
HTTP Received Kbytes
Kilobytes of data received by reported
http_nrecv
and
http_recv
commands.