beautypg.com

Miscellanous facts – HP Neoview Release 2.5 Software User Manual

Page 50

background image

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