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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-12
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-12) and when the session is terminated (see Table 3-8
on page 3-13).
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.
Component Name of the MXCS component to which the statistics apply.
UserName User name logged into the session (the logical name used at the
time of connection).
UserID User ID that is logged into the session.
ClientID Client workstation TCP/IP name or the NetBios/network name.
Application ID Client application name or the main window caption.
DataSource Client data source name used at the time of connection.
NodeName Name of the NonStop server used by the data source.
CpuPin NonStop Kernel CPU number in which the MXCS server is running,
followed by the process ID of the server.
Table 3-6. Statement Statistics - SQLFetch
Statistic Value