Miscellanous facts – HP Neoview Release 2.5 Software User Manual
Page 50
Description
Metric
Number of Executor server processes created.
Processes Created
Processor (CPU) utilization by the disk process.
Disk Process BusyTime
Processor (CPU) utilization by Neoview SQL.
SQL CPU Time
Amount of time to create Executor Server Processes (ESPs).
Process Create Time
Amount of time spent on opens.
Open Time
Total space allocated by Neoview SQL. Space is the memory allocated
at compile time.
SQL Space Alloc
Total space used by Neoview SQL.
SQL Space Used
Total heap allocated by Neoview SQL. Heap is the memory allocated
at runtime.
SQL Heap Alloc
Total heap used by Neoview SQL.
SQL Heap Used
Total space allocated by the executor in the disk process.
EID Space Alloc
Total space used by the executor in the disk process.
EID Space Used
Total heap allocated by the executor in the disk process.
EID Heap Alloc
Total heap used by the executor in the disk process.
EID Heap Used
Total memory allocated for the query.
Total Memory Allocated
Miscellanous Facts
This “catch-all” bucket contains other facts about the query. Depending on the version of the
platform to which you are connected, the information displayed will vary. This document provides
a short description about the metrics:
Description
Metric
Query identifier.
Query ID
State of the query.
State
Role name associated with the query (role of the user running the
query).
Role Name
Name of the application that initiated this query.
Application ID
Client host name.
Client ID
The Neoview WMS service under which the query is running.
Service
Name of the master process of the query.
Process Info
Type of SQL statement.
SQL Type
Statement ID of the query (part of the Query ID).
Statement ID
Type of DML statement.
Statement Type
The substate of the query.
Substate
Warning levels triggered by this query (rules violations).
Warning Level
Neoview WMS internal field containing the concatenated client and
application information.
Query Name
Name of the user connected to the server.
User Name
Name of the data source for the connection.
Datasource
50
Neoview Workload Management Services (WMS) Configuration