Spotlight on SAP ASE 2.12 - Getting Started Guide

Data Read Rate graph

The Data Read Rate graph depicts rates for retrieving buffered data pages belonging to the tablespace over consecutive intervals. These rates are based on the number of pages read per second. The graph contains the following series:

• Logical —Plots the rate of read requests for data pages (belonging to the tablespace) that are already in the buffer pool.

• Physical —Plots the rate at which logical read requests required actual I/O on the tablespace to get the data pages into the buffer pool first. When the physical read rate is consistently higher than the logical read rate, the buffer pool is not being used effectively.

For related statistical information

The Statistics tab shows the buffer pool read counts used to generate this graph.