MX 3.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—640327-001

3-23

Collecting Server Statistics

Statement Statistics: SQLPrepare

SQLPrepare statistics are written to the alternate EMS collector at the time a

PREPARE statement is received (listed in the order written in the event message):

StatementID Unique statement ID generated by the MXCS SQL server at the time

the PREPARE statement is received.

EstimatedCost Estimated query cost returned by the SQL compiler.

StatementType Valid types are: Insert, Delete, Update, Select.

ODBCElapsedTime Total MXCS SQL server real time, in microseconds, from the time the

execdirect started to the time the results are sent back.

ODBCExecutionTi

Total MXCS SQL server CPU process time, in microseconds, from the

time the execdirect started to the time the results are sent back.

NumberOfRows (ins/upd/del) Number of rows that were inserted, updated, or deleted.

ErrorCode Execdirect error code, if any. A zero (0) indicates that the execdirect

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.

Statistic Description

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 zero (0) and is incremented by 1 with each new record.

StatementID Unique statement ID generated by the MXCS SQL server at the time

the PREPARE statement is received.

EstimatedCost Estimated query cost.