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

Query Entity Attributes
Table 6-4 describes the attributes displayed on the Query entity screen. As the two rightmost
columns show, several Query entity attributes are not displayed in the graph or grid areas of the
screen (for example, BusyESPCPU, BusyESPPIN, and BusyESPSeg).
Table 6-4 Query Entity Attributes
Default Attribute for
Grid?
Default Attribute
for Graph?
DescriptionAttribute
YesNoThe name of the application as supplied by
Neoview SQL.
AppID
YesYesBusy percentage value for the busiest Neoview
SQL executor process (ESP) found in the query.
BusiestESP
NoNoProcessing node of the busiest ESP.BusyESPCPU
NoNoPIN of the busiest ESP.BusyESPPIN
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 91