CAM Database Connection Pool Test

This test monitors the connection pools configured on the target CAM Payment System and reports the number of connections, used connections, and percentage usage of the connection pool. As a result, this test helps to identify whether any connection pool is being over-utilized and, hence, running out of free connections. This way, the test reveals how well the connection pools have been used.

Target of the test : A CAM Payment System

Agent deploying the test : A remote agent

Outputs of the test : One set of results for the target CAM Payment System being monitored.

Configurable parameters for the test

Parameter	Description
Test Period	How often should the test be executed.
Host	The host for which the test is to be configured.
Port	The port number at which the target application listens. The default is 7077.
URL	In this text box, specify the URL to be accessed by this test for extracting the CAM Payment System's performance statistics.
Username	Specify the Username for accessing the URL specified in the URL text box.
Password	Specify the Password of the above mentioned user in this text box.
Confirm password	Confirm the password by retyping it here.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
DB current pool size	Indicates the current number of connections in the pool.	Number	This measure inidcates the current size of the connection pool.
DB used connection count	Indicates the number of connections that were used from the pool.	Number
Total usage	Indicates the percentage utilization of the pool.	Percent	A value close to 100% is a cause for concern, as it implies that the pool is rapidly running out of free connections. Without free connections, the target application may not be able to service subsequent connection requests from users. To avoid this, you may want to allocate more connections to the pool.