JDBC connection pool counters
Java™ Database Connectivity (JDBC) connection pool counters are used to monitor the performance of JDBC data sources.
Performance Monitoring Infrastructure (PMI) collects performance data for JDBC data sources. For PMI, data sources are identified by their Java Naming and Directory Interface (JNDI) name. To learn more about the PMI data classification, statistic types of the connection pool counters, or how pool counters are calculated, see PMI data classification.
The JDBC connection pool counters are used to monitor the performance of JDBC data sources. You can find the data by using the Tivoli® performance viewer and looking under each application server by clicking .
Note: With the instrumentation level set to anything other than MAX, the values might be less
accurate for TimeStatistics and CountStatistics. CountStatistics, such as numConnectionHandles, can
even be negative if counters are not synchronized. Synchronizing counters is expensive, so it is
only done when the instrumentation level is set to MAX.
Counter definitions
| Name | Key | ID | Description | Granularity | Statistic Type | Level | Overhead |
|---|---|---|---|---|---|---|---|
| CreateCount | connectionPoolModule.numCreates | 1 | The total number of managed connections that were created since pool creation. | Per connection pool | CountStatistic | All | Low |
| CloseCount | connectionPoolModule.numDestroys | 2 | The total number of managed connections that were destroyed since pool creation. | Per connection pool | CountStatistic | All | Low |
| AllocateCount | connectionPoolModule.numAllocates | 3 | The total number of managed connections that were allocated since pool creation. | Per connection pool | CountStatistic | Extended | Low |
| ReturnCount | connectionPoolModule.numReturns | 4 | The total number of managed connections that were returned since pool creation. | Per connection pool | CountStatistic | Extended | Low |
| PoolSize | connectionPoolModule.poolSize | 5 | The size of the connection pool. | Per connection pool | BoundedRangeStatistic | All | High |
| FreePoolSize | connectionPoolModule.freePoolSize | 6 | The number of managed connections that are in the free pool. | Per connection pool | BoundedRangeStatistic | Basic | High |
| WaitingThreadCount | connectionPoolModule.concurrentWaiters | 7 | The number of threads that are currently waiting for a connection. | Per connection pool | RangeStatistic | All | High |
| FaultCount | connectionPoolModule.faults | 8 | The total number of faults, such as timeouts, in the connection pool. | Per connection pool | CountStatistic | Extended | Low |
| PercentUsed | connectionPoolModule.percentUsed | 9 | The percent of the pool that is in use. | Per connection pool | RangeStatistic | Basic | High |
| PercentMaxed | connectionPoolModule.percentMaxed | 10 | The percent of the time that all connections are in use. | Per connection pool | RangeStatistic | All | High |
| UseTime | connectionPoolModule.avgUseTime | 12 | The average time in milliseconds that a connection is in use. | Per connection pool | TimeStatistic | All | Medium |
| WaitTime | connectionPoolModule.avgWaitTime | 13 | The average waiting time in milliseconds until a connection is granted if a connection is not currently available. | Per connection pool | TimeStatistic | All | Medium |
| ManagedConnectionCount | connectionPoolModule.numManagedConnections | 14 | The total number of managed connections in the free, shared, and unshared pools. | Per connection factory | CountStatistic | All | Low |
| ConnectionHandleCount | connectionPoolModule.numConnectionHandles | 15 | The number of connections that are in use. Can include multiple connections that are shared from a single managed connection. | Per connection factory | CountStatistic | All | Low |
| PrepStmtCacheDiscardCount | connectionPoolModule.prepStmtCacheDiscards | 21 | The total number of statements that are discarded by the least recently used (LRU) algorithm of the statement cache. | Per connection pool | CountStatistic | Extended | Low |
| JDBCTime | connectionPoolModule.jdbcOperationTimer | 22 | The average time in milliseconds spent running in the JDBC driver that includes time that is spent in the JDBC driver, network, and database. | Per data source | TimeStatistic | Extended | Medium |