Db Lock Waits Test
This test reports the number of requests that are awaiting locks.
Target of the test : A MaxDB server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every lock type operational on the MaxDB server being monitored.
| 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. |
| Measurement | Description | Measurement Unit | Interpretation |
|---|---|---|---|
|
Lock waits |
Indicates the number of lock waits currently in the database. |
Number |
Lock waits can be caused by transactions that take too long to execute. Long wait times can also occur when various applications want to lock the same object. |
