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

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-20
Collecting Server Statistics
Session Statistics: Connection Information
Session statistics are written to the alternate EMS collector at the time the connection
is made (listed in the order written in the event message):
Session Statistics: Session Summary Information
Session statistics are written to the alternate EMS collector when the session is
terminated (listed in the order written in the event message):
Statistic Description
Session ID Unique session ID generated by the MXCS server at the time the
connection is established.
Message Attribute SESSION:ConnectionInformation (the 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.
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.
ApplicationId Client application name or the main window caption.
DataSource Client data source name used at the time of connection.
NodeName Name of the Neoview platform used by the data source.
CpuPin Operating system CPU number in which the MXCS server is running,
followed by the process ID of the server.
Statistic Description
Session ID Unique session ID generated by the MXCS SQL server at the time the
connection is established.
Message Attribute SESSION:Summary (the 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.
StartTime Time when the connection request was received.
EndTime Time when the session was terminated due to an application request
or a server idle timeout.
StartPriority Execution priority of the MXCS process at the time the connection
request is received.
TotalOdbcExecutio
n Time
Total MXCS SQL server CPU process time, in microseconds, from the
time the connection started to the time the connection closed; does
not include Neoview SQL compiler time.