Progress User I/O Test
This test auto-discovers the users on the target Progress database server and periodically reports the read-write activity of each user. Using this test, administrators can easily identify which user is performing resource intensive I/O operations. This way, this test reveals the irregularities in the I/O operations performed by the users and further analyze the real reason behind the abnormally high I/O operations performed by the user.
Target of the test : A Progress Database server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every user on the target Progress database server being monitored
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. |
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Access rate |
Indicates the rate at which database access operations were performed by this user during the last measurement period. |
Accesses/Sec
|
|
Reads |
Indicates the rate at which read operations were performed on the database by this user during the last measurement period. |
Reads/Sec |
|
Writes |
Indicates the rate at which write operations were performed on the database by this user during the last measurement period. |
Writes/Sec |
|
Before-image reads |
Indicates the rate at which read operations were performed on the Before-image files by this user during the last measurement period. |
Reads/Sec |
|
Before-image writes |
Indicates the rate at which write operations were performed on the Before-image file by this user during the last measurement period. |
Writes/Sec |
|
After-image reads |
Indicates the rate at which read operations were performed on the After-image files by this user during the last measurement period. |
Reads/Sec |
|
After-image writes |
Indicates the rate at which write operations were performed on the After-image files by this user during the last measurement period. |
Writes/Sec |
|