MX 2.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

3-8

Resource Statistics

MXCS Server can collect these statistics:

•

Session Statistics

Connection information

Session summary

•

Statement Statistics

SQL statement — shows the text of the SQL query for individual SQL

statements executed but does not include other statistics

Statistical data about individual statements

SQLExecDirect

SQLExecute

SQLPrepare

SQLFetch

You may choose any combination of options. For example, choosing SQL statement

plus one or more of the individual statements returns the SQL statement that was

executed and the statistics for that statement. Choosing SQL Statement alone returns

the text of the SQL query for individual SQL statements. See Example resource

statistics output for three selected options on page 3-14.

Use NSM/web or MXCI to select these options for collecting resource statistics. See

Starting Statistics Collection on page 3-15.

Statement Statistics - Statements and Values

SQL Statement

Statement statistics are written to the alternate EMS collector at the time a Prepare

statement is received.

Table 3-2. Statement Statistics - SQL Statement

Statistic Value

Session ID Unique session ID generated by the MXCS SQL server at the time

the connection is established.

Message Attribute STATEMENT:SQLStatement (the 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.

SQL Text Text of the SQL statement. This field can be distributed in multiple

messages.