Db Query Test

A QUERY statement specifies a result table that can be ordered. This test monitors the different types of QUERY statements that are executed on the MaxDB database.

Target of the test : A MaxDB server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for 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
Create statements	Indicates the number of CREATE statements that were executed in the last measurement period.	Number
Alter statements	Indicates the number of ALTER statements that were executed in the last measurement period.	Number
Drop statements	Indicates the number of DROP statements that were executed in the last measurement period.	Number
Insert statements	Indicates the number of INSERT statements that were executed in the last measurement period.	Number
Insert row statements	Indicates the number of rows inserted in the last measurement period.	Number
Update statements	Indicates the number of UPDATE statements that were executed in the last measurement period.	Number
Update row statements	Indicates the number of rows that were updated in the last measurement period.	Number
Delete statements	Indicates the number of DELETE statements that were executed in the last measurement period.	Number
Delete row statements	Indicates the number of rows that were deleted in the last measurement period.	Number