Connections
Thisnumber 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
numberof connections is consistently higher than the minimum number of connections,
considerincreasing the minimum number of connections to be closer to the number of current
JDBCconnections. To change the minimum connections for a JDBC resource through the
AdminConsole, on the Edit JDBC Resources page, edit the Minimum Connections setting. To
changethe JDBC resource's minimum connections through the command-line-interface, use
wadmset-jdbc-resource-prop and change the min-connections property.
FreeConnections
Thisnumber shows the current number of free connections in the pool. All free connections
overthe minimum pool size are closed if they are idle for more than the maximum idle timeout.
Thefree connections are not tunable.
LeasedConnections
Thisnumber 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
leasedconnections is consistently higher than minimum connections, consider increasing the
minimumconnections. If number of leased connections is consistently at the JDBC resource's
maximumnumber of connections, consider increasing the maximum number of connections.
Theupper limit for the number of leased connections is the number of maximum connections.
Tochange 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
throughthe command-line-interface, use wadm set-jdbc-resource-prop and change the
min-connectionsor max-connections properties.
QueuedConnections
Thisnumber shows the current number of requests for connections that are waiting to receive a
connectionfrom the JDBC pool. Connection requests are queued if the current number of
leasedconnections has reached the maximum connections.
Tuning– If this number is consistently greater than zero, consider increasing the JDBC
resource'smaximum connections. To change the maximum connections for a JDBC resource
throughthe 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-connectionsproperty.
UsingMonitoringData to TuneYour Server
SunJavaSystem Web Server 7.0 Update 1 Performance Tuning,Sizing, and Scaling Guide •74