Neoview Workload Management Services Guide (R2.5)

DescriptionName
Total number of SQLExecute callsTotal Executes
Total number of SQLFetch callsTotal Fetches
Total number of SQL INSERT statements sent by the HP ODBC driver to the NDCS
server. Does not include internally generated SQL statements.
Total Insert Stmts Executed
Time in microseconds spent on login, including processing steps on the Neoview
platform and, for database users, the time required for interaction with the external
authentication server. This metric does not include processing steps on the workstation
where the login occurred.
Total Login Elapsed Time
Mcsec
Total NDCS server CPU time, in microseconds, from the time the connection started
to the time it was closed. Does not include Neoview SQL compile time.
Total Master Exec Execution
Time
Total NDCS server real time, in microseconds, from the time the connection started
to the time it was closed
Total Odbc Elapsed Time
Total number of SQLPrepare callsTotal Prepares
Total number of SQL SELECT statements sent by the HP ODBC driver to the NDCS
server. Does not include internally generated SQL statements.
Total Select Stmts Executed
Total number of SQL UPDATE statements sent by the HP ODBC driver to the NDCS
server. Does not include internally generated SQL statements.
Total Update Stmts Executed
Total number of SQL statement warnings detected by the NDCS serverTotal Warnings
Deprecated internal representation of a Neoview roleUser Id
Name, used at time of connection, to identify a Neoview userUser Name
Understand the Statement Counters
The Live View displays the current state of the queries that are being managed by WMS in the
Statement Counters box near the bottom of the window:
The Statement Counters box displays the total number of queries in the running (executing),
completed, waiting, and hold (holding or suspended) states. The Live View displays and counts
completed queries only if the queries have completed within the last minute (or 60 seconds).
After one minute, a completed query disappears from the Live View and is no longer counted
in the Statement Counters.
The Live View updates this display every 30 seconds by default.
Monitor Queries 139