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

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 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.