Manualshelf

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

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series
41424344454647484950
Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-13
Resource Statistics
Session Statistics - Summaries and Values
Session statistics are written to the alternate EMS collector at the time a connection is
made (see Table 3-7 on page 3-13) and when the session is terminated (see Table 3-8
on page 3-14).
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).
LockEscalation Cumulative number of times record locks are escalated to file
locks.
ODBCElapsedTime Total MXCS SQL server real time, in microseconds, from the time
the fetch was prepared to the time it was closed.
ODBCExecutionTime Total MXCS SQL server CPU process time, in microseconds,
from the time the fetch was prepared to the time it was closed
TotalExecutes Total number of executes performed on the statement.
Table 3-7. Session Statistics - Connection Information
Statistic Value
Session ID Unique session ID generated by the MXCS SQL server at the time
the connection is established.
Message Attribute SESSION:ConnectionInformation (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.