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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-11
Resource Statistics
SQLFetch
SQLFetch statistics are written to the alternate EMS collector at the time a statement is
closed.
Table 3-5. Statement Statistics - SQLPrepare
Statistic Value
Session ID Unique session ID generated by the MXCS SQL server at the time
the connection is established.
Message Attribute STATEMENT:SQLPrepare (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.
EstimatedCost Estimated query cost.
StatementType Valid types are: Insert, Delete, Update, Select.
SQLCompileTime Total MXCS SQL server real time, in microseconds, from the time the
prepare starts to the time it returns to the client with the compile
results,
ErrorCode Prepare error code, if any. A zero (0) indicates that the prepare was
successful.
Table 3-6. Statement Statistics - SQLFetch
Statistic Value
Session ID Unique session ID generated by the MXCS SQL server at the
time the connection is established.
Message Attribute STATEMENT:SQLFetch/SQLClose (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.
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).