The buffer monitor allows you to look at the statistical data on the table buffer and on individual tables.
To start the buffer monitor, proceed as follows:
An overview of all the buffers and database calls appears.
The system gives you the following functionality to analyze your buffer:
Function | Description |
---|---|
History |
By choosing with the quick info text History, you can look at the buffer utilization of your server during the last few days. |
Current Parameters On the new screen you can use the following functions:
|
A new screen is called, where you can see the current valid profile parameters for the buffer sizes.
|
Detail analysis menu To see the detailed information of the appropriate buffer, in the Detail analysis menu choose:
To call the table statistics, in the Detail analysis menu choose Call statistics. A new screen appears, where you can choose the criteria for the statistics that must be displayed. After you have defined the searched statistics, choose show statistics. |
In the Detail analysis menu you can display detailed information about the generic/full table buffer or single-record table buffer.
You use the table statistics to analyze the effectiveness of an existing buffer. The values that are displayed help you optimize the buffer parameters in the system profile and search for unfavorably buffered tables. |