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

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

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:

  • To narrow the set of qualifying rows (by scanning the rows in a certain range of the index) before accessing the base table.
  • To order the output.
  • To retrieve the requested column data directly. If all of the requested data is in the index, the indexed table does not need to be accessed. This is known as an index-only access.

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