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