Connections
This number shows the current JDBC connections, including both free and busy connections.
Tuning – This setting cannot be tuned, but it is a good indicator of recent pool activity. If the
number of connections is consistently higher than the minimum number of connections,
consider increasing the minimum number of connections to be closer to the number of current
JDBC connections. To change the minimum connections for a JDBC resource through the
Admin Console, on the Edit JDBC Resources page, edit the Minimum Connections setting. To
change the JDBC resource's minimum connections through the command-line-interface, use
wadm set-jdbc-resource-prop and change the min-connections property.
Free Connections
This number shows the current number of free connections in the pool. All free connections
over the minimum pool size are closed if they are idle for more than the maximum idle timeout.
The free connections are not tunable.
Leased Connections
This number shows the current number of connections in use.
Tuning – If number of leased connections is consistently lower than the minimum
connections, consider reducing the minimum connections for the JDBC resource. If number of
leased connections is consistently higher than minimum connections, consider increasing the
minimum connections. If number of leased connections is consistently at the JDBC resource's
maximum number of connections, consider increasing the maximum number of connections.
The upper limit for the number of leased connections is the number of maximum connections.
To change the minimum or maximum connections for a JDBC resource through the Admin
Console, on the Edit JDBC Resource page, edit the Minimum Connections or Maximum
Connections elds. To change the JDBC resource's minimum or maximum connections
through the command-line-interface, use wadm set-jdbc-resource-prop and change the
min-connections or max-connections properties.
Queued Connections
This number shows the current number of requests for connections that are waiting to receive a
connection from the JDBC pool. Connection requests are queued if the current number of
leased connections has reached the maximum connections.
Tuning – If this number is consistently greater than zero, consider increasing the JDBC
resource's maximum connections. To change the maximum connections for a JDBC resource
through the Admin Console, on the Edit JDBC Resource page, edit the Maximum Connections
eld. To change the JDBC resource's maximum connections through the
command-line-interface, use wadm set-jdbc-resource-prop and change the
max-connections property.
UsingMonitoringDatatoTuneYour Server
SunJavaSystemWebServer7.0Update1 PerformanceTuning,Sizing,and ScalingGuide •74