SQL/MX Connectivity Service Manual (SQL/MX 2.x)

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-9
Resource Statistics
SQLExecute
SQLExecute statistics are written to the alternate EMS collector at the time an Execute
statement is received.
SQLExecDirect
SQLExecDirect statistics are written to the alternate EMS collector at the time an
Execute statement is received.
Table 3-3. Statement Statistics - SQLExecute
Statistic Value
Session ID Unique session ID generated by the MXCS SQL server at the time
the connection is established.
Message Attribute STATEMENT:SQLExecute (the Statistics option that was selected.)
Sequence Number Message sequence number generated by MXCS. The number
begins with 0 (zero) and is incremented by 1 with each new record.
StatementID Unique statement ID generated by the MXCS SQL server at the
time the Prepare command is received.
ODBCElapsedTime Total MXCS SQL server real time, in microseconds, from the time
the execute started to the time the results are sent back.
ODBCExecutionTi
me
Total MXCS SQL server CPU process time, in microseconds, from
the time the execute started to the time the response is sent back to
the client with the results error code.
NumberOfRows
(ins/upd/del)
Number of rows that were inserted, updated, or deleted.
ErrorCode Execute error code, if any. A zero (0) indicates that the execute was
successful.
RowsAccessed Cumulative number of rows accessed.
RowsRetrieved Cumulative number of rows retrieved.
DiscReads Cumulative number of disk reads.
MsgsToDisc Number of messages sent to the disk process.
MsgsBytesToDisc Size, in bytes, of the total number of messages sent to the disk
process.
LockWaits Number of lock waits (this is the concurrency cost).
LockEscalation Cumulative number of times record locks are escalated to file locks.