Chat now with support
Chat with Support

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.

Buffer Pool Name

Page Size (bytes)

Extended Data Pages Out

Buffer Pool ID

Total Size

Extended Index Pages Out

Node Group

Uses Extended Storage

Extended Data Pages In

Database

Files Closed

Extended Index Pages In

Pages

 

 

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

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating