HP Neoview Release 2.4 Software - Manual (Page 45)

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):
Description Statistic
Unique session ID generated by the NDCS SQL server at the time the connection is established. Session ID
STATEMENT:SQLPrepare (Statistics option that was selected.) Message Attribute
Message sequence number generated by NDCS The number begins with zero (0) and is
incremented by 1 with each new record. Sequence Number
Unique statement ID generated by the NDCS SQL server at the time the PREPARE statement
is received. StatementID
Estimated query cost. EstimatedCost
Valid types are: Insert, Delete, Update, Select. StatementType
Total NDCS SQL server real time, in microseconds, from the time the prepare started to the
time it returns to the client with the compile results. SQLCompileTime
Prepare error code, if any. A zero (0) indicates that the prepare was successful. ErrorCode
Statement Statistics: SQLFetch
SQLFetch statistics are written to the alternate EMS collector at the time a statement is closed
(listed in the order written in the event message):
Description Statistic
Unique session ID generated by the NDCS SQL server at the time the connection is
established. Session ID
STATEMENT:SQLFetch/SQLClose (Statistics option that was selected.) Message Attribute
Message sequence number generated by NDCS The number begins with zero (0) and
is incremented by 1 with each new record. Sequence Number
Unique statement ID generated by the NDCS SQL server at the time the PREPARE
statement is received. StatementID
Cumulative number of rows accessed. RowsAccessed
Cumulative number of rows retrieved. RowsRetrieved
Cumulative number of disk reads. DiscReads
Number of messages sent to the disk process. MsgsToDisc
Size, in bytes, of the total number of messages sent to the disk process. MsgsBytesToDisc
Number of lock waits (this is the concurrency cost). LockWaits
Cumulative number of times record locks are escalated to file locks. LockEscalation
Total NDCS SQL server real time, in microseconds, from the time the fetch was prepared
to the time it was closed. TotalOdbcElapsedTime
Total NDCS SQL server CPU process time, in microseconds, from the time the fetch was
prepared to the time it was closed. TotalOdbcExecutionTime
Total number of executes performed on the statement. TotalExecutes
View Event Messages 45