Db I/O Stats Test

This test indicates how efficiently MaxDB handles read/write requests to the database.

Target of the test : A MaxDB server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every data volume and log volume on the MaxDB server being monitored.

Configurable parameters for the test
Parameter	Description
Test Period	How often should the test be executed.
Host	The host name of the server for which the test is to be configured.
Port	The port number to which the server is listening.
DatabaseName	The test connects to a database on MaxDB and extracts performance statistics from the system tables in the database. Therefore, provide the name of a database in the DatabaseName text box.
Username	Since users with the SYSDBA privilege alone are allowed access to system tables, specify the name of such a user against Username.
Password	Provide the Password that corresponds to the specified Username.
Confirm Password	Confirm the password by retyping it here.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
Database read rate	Indicates the rate at which database reads were performed.	Reads/Sec
Page read operations	Indicates the rate at which page reads were performed.	Pages/Sec
Database read time	Indicates the time taken by the database to perform read operations in the last measurement period.	Secs	A high value of this measure indicates a reading bottleneck.
Database write rate	Indicates the rate at which data is written to the database.	Writes/Sec
Page write operations	Indicates the rate at which page writes were performed.	Pages/Sec
Database write time	Indicates the time taken by the database to perform write operations in the last measurement period.	Secs	A high value of this measure indicates a writing bottleneck.
Pending I/O operations	Indicates the number of IO operations still to be completed.	Number	If the value of this measure keeps increasing, it is indicative of a processing bottleneck.