Progress Buffer Status Test

This test monitors the usage of the buffer memory of the Progress database server.

Target of the test : A Progress Database server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the target Progress database server that is to be monitored

Configurable parameters for the test
Parameter	Description
Test Period	How often should the test be executed
Host	The IP address of the Progress database server.
Port	The port number on which the database server is listening. By default, this is NULL.
Database Name	Specify the name of the Progress database instance that is to be monitored.
Username	In order to monitor a Progress database instance, a special database user account has to be created in every Progress database instance that requires monitoring. This special user needs to be granted a set of privileges. To know how to create the database user and grant the required privileges, refer to Pre-Requisites for monitoring the Progress database. Specify the name of such a user in this text box.
Password	The password of the specified Username.
Confirm Password	Confirm the password by retyping it here.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
Total buffers	Indicates the total number of buffers in the buffer cache of the database.	Number
Used buffers	Indicates the total number of buffers that were used.	Number
Modified buffers	Indicates the number of buffers that were modified.	Number
Buffer usage	Indicates the percentage of buffers that were used.	Percent	A consistent value of 100 may lead to processing bottlenecks as the request processing may considerably degrade due to non availability of the buffers.
Modified buffer usage	Indicates the percentage of buffers that were modified.	Percent
Buffers marked for checkpoint	Indicates the number of blocks that were scheduled to be written to the buffer before the end of the checkpoint.	Number
Buffers in checkpoint queue	Indicates the number of buffers in the checkpoint queue.	Number
Buffers in page writer queue	Indicates the number of buffers in the page writer queue.	Number