Sybase 12.5.1, Руководство пользователя

Страница: 138 / 210

Table of valid key and result data item combinations
124
Historical Server
• Views that contain keys other than those listed in the previous bullets
return rows when there is no activity.
Table of valid key and result data item combinations
There are restrictions on the data items that can be combined within a view. The
restrictions are based upon the relationships between data items. For example,
it makes no sense to ask for “CPU Busy Percent” per “Page Number”;
therefore, it is not allowed.
Table B-2 shows valid combinations of result and key data items for views. The
table lists result data items in alphabetical order. The basic rules for
determining whether a result data item can be included in a recording session
view are:
• The view must include all of the required keys listed for the result data
item.
• The view can include the optional keys listed for the result data item.
However, not all of the optional keys listed for a data item are guaranteed
to work together.
• The view cannot include any other keys besides those listed as required or
optional. (A few exceptions are described in the Notes column.)
• Data Available at Server Level? – indicates whether this data item can be
used in a view without any keys to obtain summary or static information
about Adaptive Server.
• A result data item that has no required keys can be used in server-level
views. Server-level views have no keys and report summary or static
information about Adaptive Server.
• Footnotes contain additional information about using the result data items
in views.
Table B-2: Valid key and result combinations
Data item Required and optional keys
Application Execution
Class
2
Valid at server level?
No
Required keys:
Application Name
Application Name (KEY)
3