Progress Indexes Test
An index is a data structure that a database uses to reduce the amount of time it takes to perform certain operations. An index can also be used to ensure that duplicate values don’t appear where they are not needed.
This test monitors the indexes on the Progress database server and helps administrators quickly and accurately assess the effectiveness of these indexes.
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
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 |
---|---|---|---|
Index create rate |
Indicates the rate at which indexes were created during the last measurement period. |
Creates/Sec |
|
Index delete rate |
Indicates the rate at which index entries were deleted during the last measurement period. |
Deletes/Sec |
|
Index scan rate |
Indicates the rate at which index entries were scanned (searched for) during the last measurement period. |
Scans/Sec |
An index scan occurs when the database manager accesses an index for any of the following reasons:
Typically, a high value of this measure is desired, as index scans are I/O-friendly operations. A high value is desired for this measure. If the value is low or falls consistently, it indicates bottlenecks while performing index scans. |
Index split rate |
Indicates the rate at which index entries were split during the last measurement period. |
Splits/Sec |
|
Index split ratio |
Indicates the ratio of index splits to the index generation during the last measurement period. |
Percent |
|