eG Datafile Details Test

By periodically monitoring the I/O activity on each datafile on the eG database server and observing the growth in size of the datafile, this test sheds light on the following:

  • Datafiles that are experiencing I/O bottlenecks;
  • Datafiles that are consuming too much disk space

Note:

This test will not report metrics when a Microsoft SQL database is configured as the backend database for the eG manager.

Target of the test : The eG manager

Agent deploying the test : An internal agent

Outputs of the test : One set of results for each datafile on the eG database.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed .

Host

The host for which the test is to be configured.

Port

The port number at which the specified host listens.

DD Frequency

Refers to the frequency with which detailed diagnosis measures are to be generated for this test. The default is 1:1. This indicates that, by default, detailed measures will be generated every time this test runs, and also every time the test detects a problem. You can modify this frequency, if you so desire. Also, if you intend to disable the detailed diagnosis capability for this test, you can do so by specifying none against DD frequency.

Detailed Diagnosis

To make diagnosis more efficient and accurate, the eG Enterprise suite embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

  • The eG manager license should allow the detailed diagnosis capability
  • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Write rate

Indicates the rate at which writes occurred on this datafile.

Writes/Sec

 

Data write rate

Indicates the rate at which data was written to this datafile.

KB/Sec

 

I/O stall writes

Indicates the total time taken to write to this datafile.

Millisecs

A high value for this measure could indicate a bottleneck while writing to the datafile. By comparing the value of this measure across datafiles, you can identify the data file to which write operations are taking too long to complete.

Read rate

Indicates the rate of reads from this datafile.

Reads/Sec

 

Data read rate

Indicates the rate at which data was read from this datafile.

KB/Sec

 

I/O stall reads

Indicates the total time taken to read from this datafile.

 

Millisecs

A high value for this measure could indicate a bottleneck while reading from the datafile.

By comparing the value of this measure across datafiles, you can identify the datafile to which read operations are taking too long to complete.

I/O stall

Indicates the total time taken for I/O to complete on this datafile.

Millisecs

A high value for this measure could indicate an I/O bottleneck on this datafile.

Size on disk

Indicates the total size on disk of each datafile.

Bytes

This measure is used to determine the growth of the datafile.

A low value is desired for this measure. A very high value, or a consistent increase in this value may adversely impact I/O operations.

You may want to consider maintaining multiple datafiles of smaller sizes to improve I/O efficiency, and to speed up backup/restore operations.