Getting individual buffer pool information

You can view individual buffer pool characteristics and individual buffer pool counters of a selected buffer pool.

Procedure

  1. In the Buffer Pools folder of the contents pane, click one of the icons representing individual buffer pools, for example BP0.
    The following items are displayed for the selected buffer pool:
    • Characteristics
    • Counters
    • Object Comparison
    • Objects
    Each item contains additional information about the selected buffer pool.
  2. If you want to see general information and thresholds of the selected buffer pool, double-click Characteristics.
    The following window is displayed:
    Figure 1. Viewing performance data – The Individual Buffer Pool Characteristics window
    This figure is a graphical representation of the Individual Buffer Pool Characteristics window from viewing performance data.

    The right pane shows general information, such as the buffer pool identifier and its virtual pool size, and thresholds for several types of buffer pool operations.

  3. If you want to see buffer pool activity counters of the selected buffer pool, double-click Counters, then double-click one of the different counters, for example Getpage
    The following window is displayed:
    Figure 2. Viewing performance data – The Individual Buffer Pool Counters window
    This figure is a graphical representation of the Individual Buffer Pool Counters window from viewing performance data.
    Note: The content pane displays only the active counters. Counters that have no activity are not displayed.

    The right pane shows the types for the selected counter Getpage in the form of a pie chart. The types are Sequential Access, Random Access, and RID List.

  4. If you want to compare object activities of the selected buffer pool, double-click Object Comparison. Then double-click one of the different counters, for example Getpage.

    A similar window is displayed. The right pane shows the types for the selected counter Getpage in the form of a bar chart. The types are Sequential Access, Random Access, and RID List. They are sorted in descending order.

  5. If you want to see all objects and their counters of the selected buffer pool, double-click Objects. Then double-click one of the different counters, for example Write Request.

    A similar window is displayed. The right pane shows the types for the selected counter Write Request in the form of a pie chart. The types are Synchronous and Asynchronous.