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. They are repeated here for convenience:

  • These data items infer names from IDs or status types. They are valid in any view containing the required keys, regardless of the other keys that might also be in the view. (For example, Database Name is valid in any view containing the key Database ID; therefore, it would be valid in a view whose keys are Database ID and Process ID.)

  • These data items are available only if you are monitoring Adaptive Server version 11.5 and later.

  • Process ID and Application Name cannot be used in the same view.

  • In previous version, Cache Name was a key. In this version, Cache Name is a result. A new key, Cache ID, replaces the key Cache Name. For compatibility, Cache Name remains valid as a key. However, for efficiency and for forward compatibility, use Cache ID as the key in new 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
  Blocking Process ID	Valid at server level? No Required keys: Process ID Database ID Object ID Lock Status Page Number Optional keys: Lock Type
  Cache Efficiency	Valid at server level? No Required keys: Cache ID
  Cache Hit Pct	Valid at server level? No Required keys: Cache ID
  Cache Hits	Valid at server level? No Required keys: Cache ID
  Cache ID (KEY) 4
  Cache Misses	Valid at server level? No Required keys: Cache ID
  Cache Name4	Valid at server level? No Required keys: Cache ID
  Cache Prefetch Efficiency	Valid at server level? No Required keys: Cache ID
  Cache Refer and Reuse	Valid at server level? No Required keys: Cache ID
  Cache Reuse	Valid at server level? No Required keys: Cache ID
  Cache Reuse Dirty	Valid at server level? Yes Required keys: None Optional keys: Cache ID
  Cache Size	Valid at server level? No Required keys: Cache ID
  Cache Spinlock Contention	Valid at server level? No Required keys: Cache ID
  Code Memory Size	Valid at server level? Yes Required keys: None
  Connect Time	Valid at server level? No Required keys: Process ID
  CPU Busy Percent	Valid at server level? Yes Required keys: None Optional keys: Engine Number
  CPU Percent3	Valid at server level? No Required keys: Process ID or Application Name Optional keys: Engine Number
  CPU Time3	Valid at server level? Yes Required keys: None Optional keys: Process ID or Application Name Engine Number
  CPU Yields	Valid at server level? Yes Required keys: None Optional keys: Engine Number
  Current Application Name	Valid at server level? No Required keys: Process ID
  Current Engine	Valid at server level? No Required keys: Process ID
  Current Execution Class2	Valid at server level? No Required keys: Process ID
  Current Process State	Valid at server level? No Required keys: Process ID
  Current Stmt Batch ID2	Valid at server level? No Required keys: Process ID
  Current Stmt Batch Text2	Valid at server level? No Required keys: Process ID
  Current Stmt Batch Text Byte Offset2	Valid at server level? No Required keys: Process ID
  Current Stmt Batch Text Enabled2	Valid at server level? Yes Required keys: None
  Current Stmt Context ID2	Valid at server level? No Required keys: Process ID
  Current Stmt CPU Time2	Valid at server level? No Required keys: Process ID
  Current Stmt Elapsed Time2	Valid at server level? No Required keys: Process ID
  Current Stmt Line Number2	Valid at server level? No Required keys: Process ID
  Current Stmt Locks Granted After Wait2	Valid at server level? No Required keys: Process ID
  Current Stmt Locks Granted Immediately2	Valid at server level? No Required keys: Process ID
  Current Stmt Locks Not Granted2	Valid at server level? No Required keys: Process ID
  Current Stmt Logical Reads	Valid at server level? No Required keys: Process ID
  Current Stmt Number 2	Valid at server level? No Required keys: Process ID
  Current Stmt Page I/O2	Valid at server level? No Required keys: Process ID
  Current Stmt Page Writes2	Valid at server level? No Required keys: Process ID
  Current Stmt Physical Reads2	Valid at server level? No Required keys: Process ID
  Current Stmt Procedure Database ID2	Valid at server level? No Required keys: Process ID
  Current Stmt Procedure Database Name2	Valid at server level? No Required keys: Process ID
  Current Stmt Procedure ID2	Valid at server level? No Required keys: Process ID
  Current Stmt Procedure Name2	Valid at server level? No Required keys: Process ID
  Current Stmt Procedure Owner Name2	Valid at server level? No Required keys: Process ID
  Current Stmt Procedure Text2	Valid at server level? No Required keys: Process ID
  Current Stmt Query Plan Text2	Valid at server level? No Required keys: Process ID
  Current Stmt Start Time2	Valid at server level? No Required keys: Process ID
  Current Stmt Text Byte Offset2	Valid at server level? No Required keys: Process ID
  Database ID (KEY)
  Database Name1	Valid at server level? No Required keys: Database ID
  Deadlock Count	Valid at server level? Yes Required keys: None
  Demand Lock	Valid at server level? No Required keys: Process ID Database ID Object ID Lock Status Page Number Optional keys: Lock Type
  Device Hit Percent	Valid at server level? Yes Required keys: None Optional keys: Device Name
  Device Hits	Valid at server level? Yes Required keys: None Optional keys: Device Name
  Device I/O	Valid at server level? Yes Required keys: None Optional keys: Device Name
  Device Misses	Valid at server level? Yes Required keys: None Optional keys: Device Name
  Device Name (KEY)
  Device Reads	Valid at server level? Yes Required keys: None Optional keys: Device Name
  Device Writes	Valid at server level? Yes Required keys: None Optional keys: Device Name
  Elapsed Time	Valid at server level? Yes Required keys: None
  Engine Number (KEY)
  Host Name	Valid at server level? No Required keys: Process ID
  Index Logical Reads	Valid at server level? Yes Required keys: None Optional keys: Process ID Database ID Object ID Engine Number Key combination: Procedure Database ID Procedure ID
  Index Physical Reads	Valid at server level? Yes Required keys: None Optional keys: Process ID Database ID Object ID Engine Number Key combination: Procedure Database ID Procedure ID
  Kernel Process ID1	Valid at server level? No Required keys: Process ID
  Kernel Structures Memory Size	Valid at server level? Yes Required keys: None
  Large I/O Denied	Valid at server level? No Required keys: Cache ID
  Large I/O Performed	Valid at server level? No Required keys: Cache ID
  Large I/O Requested	Valid at server level? No Required keys: Cache ID
  Lock Count	Valid at server level? Yes Required keys: None Optional keys: Process ID Lock Type Lock Result Lock Results Summarized
  Lock Hit Percent	Valid at server level? Yes Required keys: None
  Lock Result (KEY)
  Lock Results Summarized (KEY)
  Lock Status (KEY)
  Lock Status Count	Valid at server level? No Required keys: Lock Status
  Lock Type (KEY)
  Locks Being Blocked Count	Valid at server level? No Required keys: Process ID Database ID Object ID Lock Status Lock Type Page Number
  Locks Granted After Wait3	Valid at server level? Yes Required keys: None Optional keys: Process ID or Application Name Key Combination: Database ID Object ID Key Combination: Procedure Database ID Procedure ID
  Locks Granted Immediately3	Valid at server level? Yes Required keys: None Optional keys: Process ID or Application Name Key Combination: Database ID Object ID Key Combination: Procedure Database ID Procedure ID
  Locks Not Granted3	Valid at server level? Yes Required keys: None Optional keys: Process ID or Application Name Key Combination: Database ID Object ID Key Combination: Procedure Database ID Procedure ID
  Log Contention Percent	Valid at server level? Yes Required keys: None
  Logical Page Reads	Valid at server level? Yes Required keys: None Optional keys: Process ID Engine Number Key combination: Database ID Object ID Key combination: Procedure Database ID Procedure ID
  Login Name1	Valid at server level? No Required keys: Process ID
  Most Active Device I/O	Valid at server level? Yes Required keys: None
  Most Active Device Name	Valid at server level? Yes Required keys: None
  Net Bytes Received	Valid at server level? Yes Required keys: None
  Net Bytes Sent	Valid at server level? Yes Required keys: None
  Net Default Packet Size	Valid at server level? Yes Required keys: None
  Net I/O Bytes	Valid at server level? Yes Required keys: None
  Net Max Packet Size	Valid at server level? Yes Required keys: None
  Net Packet Size Received	Valid at server level? Yes Required keys: None
  Net Packet Size Sent	Valid at server level? Yes Required keys: None
  Net Packets Received	Valid at server level? Yes Required keys: None
  Net Packets Sent	Valid at server level? Yes Required keys: None
  Number of Engines	Valid at server level? Yes Required keys: None
  Number of Processes2	Valid at server level? Yes Required keys: None Optional keys: Application Name
  Object ID (KEY)
  Object Name1	Valid at server level? No Required keys: Database ID Object ID
  Object Type1	Valid at server level? No Required keys: Database ID Object ID
  Owner Name1	Valid at server level? No Required keys: Database ID Object ID
  Page Cache Size	Valid at server level? Yes Required keys: None
  Page Hit Percent	Valid at server level? Yes Required keys: None Optional keys: Process ID Engine Number Key combination: Database ID Object ID Key combination: Procedure Database ID Procedure ID
  Page I/O	Valid at server level? Yes Required keys: None Optional keys: Process ID Engine Number Key combination: Database ID Object ID Key combination: Procedure Database ID Procedure ID
  Page Number(KEY)
  Page Writes	Valid at server level? Yes Required keys: None Optional keys: Process ID Engine Number Key combination: Database ID Object ID Key combination: Procedure Database ID Procedure ID
  Physical Page Reads	Valid at server level? Yes Required keys: None Optional keys: Process ID Engine Number Key combination: Database ID Object ID Key combination: Procedure Database ID Procedure ID
  Procedure Buffer Size	Valid at server level? Yes Required keys: None
  Procedure CPU Time	Valid at server level? No Required keys: Procedure Database ID Procedure ID Optional keys: Process ID Procedure Stmt Number Procedure Line Number
  Procedure Database ID (KEY)
  Procedure Database Name1	Valid at server level? No Required keys: Procedure Database ID
  Procedure Elapsed Time	Valid at server level? No Required keys: Procedure Database ID Procedure ID Optional keys: Process ID Procedure Stmt Number Procedure Line Number
  Procedure Execution Class2	Valid at server level? No Required keys: Procedure Database ID Procedure ID
  Procedure Execution Count	Valid at server level? No Required keys: Procedure Database ID Procedure ID Optional keys: Process ID Procedure Stmt Number Procedure Line Number
  Procedure Header Size	Valid at server level? Yes Required keys: None
  Procedure Hit Percent	Valid at server level? Yes Required keys: None
  Procedure ID (KEY)
  Procedure Line Number (KEY)
  Procedure Line Text	Valid at server level? No Required keys: Procedure Database ID Procedure ID
  Procedure Logical Reads	Valid at server level? Yes Required keys: None
  Procedure Name1	Valid at server level? No Required keys: Procedure Database ID Procedure ID
  Procedure Owner Name1	Valid at server level? No Required keys: Procedure Database ID Procedure ID
  Procedure Physical Reads	Valid at server level? Yes Required keys: None
  Procedure Statement Number (KEY)
  Process ID (KEY)3
  Process State (KEY)
  Process State Count	Valid at server level? No Required keys: Process State
  Rows Deleted	Valid at server level? Yes Required keys: None
  Rows Deleted Deferred	Valid at server level? Yes Required keys: None
  Rows Deleted Direct	Valid at server level? Yes Required keys: None
  Rows Inserted	Valid at server level? Yes Required keys: None
  Rows Inserted Clustered	Valid at server level? Yes Required keys: None
  Rows Inserted Heap	Valid at server level? Yes Required keys: None
  Rows Updated	Valid at server level? Yes Required keys: None
  Rows Updated Deferred	Valid at server level? Yes Required keys: None
  Rows Updated Direct	Valid at server level? Yes Required keys: None
  Rows Updated Expensive	Valid at server level? Yes Required keys: None
  Rows Updated In Place	Valid at server level? Yes Required keys: None
  Rows Updated Not In Place	Valid at server level? Yes Required keys: None
  Select Statements	Valid at server level? Yes Required keys: None
  Server Structures Size	Valid at server level? Yes Required keys: None
  SQL Server Name	Valid at server level? Yes Required keys: None
  SQL Server Version	Valid at server level? Yes Required keys: None
  Thread Exceeded Max2	Valid at server level? Yes Required keys: None
  Thread Exceeded Max Percent2	Valid at server level? Yes Required keys: None
  Thread Max Used2	Valid at server level? Yes Required keys: None
  Time Waited on Lock	Valid at server level? No Required keys: Process ID Database ID Object ID Lock Status Page Number Optional keys: Lock Type
  Timestamp	Valid at server level? Yes Required keys: None
  Timestamp Datim	Valid at server level? Yes Required keys: None
  Transactions	Valid at server level? Yes Required keys: None
  1. These data items infer names from IDs or status types. They are valid in any view containing the required keys, regardless of the other keys that might also be in the view. (For example, Database Name is valid in any view containing the key Database ID; therefore, it would be valid in a view whose keys are Database ID and Process ID.) 2. These data items are available only if you are monitoring Adaptive Server Version 11.5 and later. 3. Process ID and Application Name cannot be used in the same view. 4. In versions earlier than 11.5, Cache Name was a key. Currently, Cache Name is a result.A new key, Cache ID, replaces the key Cache Name. For compatibility, Cache Name remains valid as a key. However, for efficiency and for forward compatibility, use Cache ID as the key in new views.

---

Copyright © 2001. Sybase Inc. All rights reserved.

View this book as PDF