Spotlight on SAP ASE 2.11 - Release Notes

Buffer Pool Analysis drilldown Details tab

The Details tab on the Buffer Pools drilldown provides the following information about the selected buffer pool:

• Configuration information

• Use of extended storage

• The amount of time required to perform I/O that involved this buffer pool

Extended storage utilization statistics

Extended storage is a secondary level of storage for buffer pools, allowing the user to access memory beyond the maximum allowed for each process. When the database has buffer pools configured for extended storage, the extended storage counters are useful. They show the number of data and index pages belonging to the tablespace that are copied in and out of extended storage. If the number of pages copied out of extended storage back into the buffer pools is higher than the number of pages copied into extended storage from the buffer pools, your database at this tablespace level is probably benefiting from extended storage.

Buffer pool identification and configuration information

The Buffer pool Details list shows current identification, extended storage, and configuration settings for the selected buffer pool.

Graph

The Buffer pool Timings bar graph compares the amount of time (in seconds) required to perform each of these types of I/O that involve the selected buffer pool.

Direct Write

Direct Read

Pool Async Write

Pool Write

Pool Async Read

Pool Read

Use the graph to get an overall sense of the time required to perform I/O involving this buffer pool.

Related topics

Buffer Pool Analysis drilldown