Neoview Workload Management Services Guide (R2.5)

DescriptionName
Time in Local Civil Time (LCT) when the query entered the Neoview WMS queue
requesting permission to execute (admission control)
Entry Ts
Time in Julian format when the query entered the Neoview WMS queue requesting
permission to execute (admission control)
Entry Jts
Rate-Based Metrics
This table describes the rate-based metrics for the query:
DescriptionName
Rate of the rows being retrieved from the systemRows/second
Amount of processor (CPU) cycles that the query is consuming (that is, the rate of
the processor usage), which is the Total Processor Time Microseconds minus the
Query Elapsed Time
Processor Usage/second
Difference between the current and previous samples of the processor (CPU)
utilization, which is the Total Processor Time minus the Last Interval Processor Time
Delta Processor Time
Difference between the current and previous samples of the amount of memory in
megabytes (MB) allocated by all the processes involved with the query
Delta Space Alloc Mb
Difference between the current and previous samples of the amount of memory in
megabytes (MB) used by all the processes involved with the query
Delta Space Used Mb
Difference between the current and previous samples of the number of disk reads
performed by all the processes involved with the query
Delta Disk Reads
Difference between the current and previous samples of the number of rows inserted,
updated, or deleted
Delta Iud
Rate of the number of rows inserted, updated, or deleted per secondIud/second
Miscellaneous Facts
This table describes miscellaneous facts about the query:
DescriptionName
Query identifierQuery Id
State of the query. For more information, see Appendix C (page 263).State
Name of the Neoview role associated with the query (that is, the role of the user who
is running the query)
Role Name
Name of the application that initiated the queryApplication Id
Client host nameClient Id
Name of the WMS service in which the query is runningService
Name of the master process of the queryProcess Info
Name of the SQL statement (for example, SELECT)Sql Type
Statement identifier of the query, which is part of the query IDStatement Id
Type of SQL statement (for example, SQL_SELECT_NON_UNIQUE). For more
information, see Appendix B (page 261).
Statement Type
Substate of the query. For more information, see Appendix C (page 263).Substate
Highest warning level triggered by the query as a result of a WMS rule evaluating
to true
Warning Level
Monitor Queries 131