Neoview Management Dashboard Client Guide for Database Administrators (R2.4)

Table 6-5 QueryRTS Entity Attributes (continued)
Default Attribute
for Grid?
Default Attribute
for Graph?
DescriptionAttribute
YesNoNeoview user name of the user who started
the query
Username
YesNoRole of the Neoview user who started the
query.
Role
YesNoName of the device from which the query was
sent.
ClientID
YesNoName of the connectivity driver used to send
the query, e.g., ODBC.
ApplID
YesYesElapsed time in minutes, the sum of queue
time, compile time, and execution time. This
number indicates the total elapsed time for a
completed query and the elapsed time so far
for a query in progress.
Walltime
YesNoIf Dashboard is behind in retrieving data from
WMS, delay time in minutes.
Lagtime
YesNoStarting priority of the Master Executor's child
processes.
Spri
YesNoMinimum priority at which Master Executor's
child processes have run. This value is updated
as the query runs.
Mpri
YesNoEstimated cost of the query, in seconds. This is
the estimated cost of SQL operations in the
Master Executor; it does not include compile
time or queue time. The estimate occurs at the
time the query is prepared.
EstCost
YesYesCumulative processor utilization for the Master
Executor and all its child processes. This value
is updated as the query runs.
TotBusy%
YesNoProcessor utilization percentage for the Master
Executor and all its child processes during the
last interval.
TotalBusyInt%
YesNoTotal number of child processes of the Master
Executor.
ESPs
YesNoTotal number of Master Executor child
processes busy during the last interval.
ESPsBusyInt
YesNoTotal number of Master Executor child
processes currently in the suspended state.
SuspESPs
YesYesCumulative processor utilization for the Master
Executor. This value is updated as the query
runs.
MstrBusy%
YesNoProcessor utilization for the Master Executor
during the last interval.
MstrBusyInt%
YesYesCumulative processor utilization percentage
for all the Executor Server Processes.
TotEsp%
YesNoProcessor utilization for all the Executor Server
Processes during the last interval.
Esp%
YesNoProcessor utilization for the busiest Executor
Server Process.
BusiestESP
QueryRTS Entity 95