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

Table 6-4 Query Entity Attributes (continued)
Default Attribute for Grid?Default Attribute for Graph?DescriptionAttribute
YesYesTotal number of ESP
processes that are as busy
as or busier than BusyVal.
BusyESPs
NoNoSegment of the busiest ESP.BusyESPSeg
NoNoBusyVal parameter, which
is always the same.
BusyVal
YesNoName of the client.ClientID
YesYesProcessor utilization for the
Neoview SQL connection
server during the last
interval.
Con%
YesNoData set name.DataSource
YesNoThe query name, which
includes the user name, the
segment name, and the
name of the connection
server.
Domain
YesYesError code, if any, last
generated by the query.
This number is negative.
ErrorCode
YesYesSystem utilization for all the
executor processes during
the last interval.
ESP%
YesNoTotal number of child
executor processes.
ESPs
YesNoMinimum priority found
among all the components
during the last interval.
MPri
YesNoParallelism of the query,
which is computed by
dividing the number of
busy ESPs by the number of
processing nodes in the
Neoview platform, then
multiplying the result by
100. The higher the parallel
value, the better the query.
Parallel
YesNoThe role identifier for which
the user ID is an alias.
Role
YesNoStarting priority of the
query.
SPri
YesNoFirst 80 bytes of SQL
statement text. Right-click
this attribute and select
Show Object Detail to
display the first 2 KB of the
SQL text.
SQLText
YesNoQuery start time.StartTime
YesNoOperational status of the
query.
Status
Query Entity 93