Jdbc Stats Test

This test collects measures like how many JDBC queries have been executed, how long those queries took to execute and what those statements are. This test is key to determining whether the database/database queries are the cause of any slowdowns with applications executing on the WebLogic server. This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle WebLogic as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the >> button to move the test to the ENABLED TESTS list. Finally, click the Update button.

Target of the test : A WebLogic Application Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for a WebLogic application server.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The IP address of the host for which this test is to be configured.

Port

The port at which the specified host listens. By default, this is NULL.

URL

The URL to be accessed to collect metrics pertaining to the WebLogic server. By default, this test connects to a managed WebLogic server and attempts to obtain the metrics of interest by accessing the local Mbeans of the server. This parameter can be changed to a value of http://<adminserverIP>:<adminserverPort>. In this case, the test connects to the WebLogic admin server to collect metrics pertaining to the managed server (specified by the Host and Port). The URL setting provides the administrator with the flexibility of determining the WebLogic monitoring configuration to use.

Note:

If the admin server is to be used for collecting measures for all the managed WebLogic servers, then it is mandatory that the egurkha war file is deployed to the admin server, and it is up and running. 

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

Total query rate

The rate of JDBC queries that have been executed on the database.

Queries/Sec

This is an indicator of the JDBC workload.

Avg query time

The average time taken by the queries to execute on the database.

Secs

A higher average query time signifies a performance bottleneck at the data abase tier.

Select query rate

The rate of select queries executed on the database.

Queries/Sec

Comparing the types of queries to the database provides an idea about the nature of workload on the database

Avg Select query time

The average time taken by the select queries for executing on the database.

Secs

Unexpectedly large query times can indicate that there is sufficient scope to optimize database access using better indexes.

Insert query rate

The rate of insert queries executed on the database.

Queries/Sec

 

Avg insert query time

The average time taken for executing the insert queries on the database.

Secs

 

Update query rate

The rate of update queries executed on the database.

Queries/Sec

 

Avg update query time

The average time taken for executing the update queries on the database.

Secs

 

Delete query rate

The rate of delete queries executed on the database.

Queries/Sec

 

Avg delete query time

The average time taken by the delete queries to execute on the database.

Secs

 

Commit queries rate

The rate of commit queries executed on the database.

Queries/Sec

 

Avg commit query time

The average time taken by the commit queries to execute on the database.

Secs

 

Rollback queries rate

The rate of rollback queries executed on the database.

Queries/Sec

Typically, the rate of rollbacks should be low.

Avg rollback query time

The average time taken by the rollback queries to execute on the database.

Secs

 

Jdbc query error rate

The rate of queries that have resulted in an error.

Errors/Sec