HP Neoview Release 2.4 Software - Manual (Page 44)

Statement Statistics: SQL Statement
Statement 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:SQLStatement (the 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
Text of the SQL statement. This field can be distributed in multiple messages. SQL Text
Statement Statistics: SQLExecute
SQLExecute statistics are written to the alternate EMS collector at the time an EXECUTE statement
is received (listed in the order written in the event message):
Description Statistic
Unique session ID generated by the NDCS server at the time the connection is
established. Session ID
STATEMENT:SQLExecute (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
Total NDCS SQL server real time, in microseconds, from the time the execute started
to the time the results are sent back. ODBCElapsedTime
Total NDCS 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. ODBCExecutionTime
(ins/upd/del) Number of rows that were inserted, updated, or deleted. NumberOfRows
Execute error code, if any. A zero (0) indicates that the execute was successful. ErrorCode
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
44 Perform Basic HPDM Operations