2.2 Connections

Connections metrics provide the connection details for the database at the agent level and at the Database Manager level. Connections metrics consist of the following categories:

2.2.1 Agents Connection

The metrics in this category return the agent connection statistics, including the configured values and the current parameter values at the database manager snapshot level.

Default Collection Interval — Every 15 minutes

Table 2-1 Agents Connection Metrics

Metric Description and User Action

Agent Created Due to Empty Pool

Number of agents created due to an empty pool.

Agent Creation Rate

Creation rate for agents in the last interval, which equals:

(agents_created_empty_pool-agents_created_empty_pool)/ __interval

Increase the value of the configuration parameter agents_created_empty_pool.

Agent Creation to Assignment Ratio

Creation to assignment ratio, which equals:

(agents_created_empty_pool /agents_from_pool)

Increase the value of the configuration parameter agents_from_pool.

Agent Limit

Number of agents the database manager can create.

Agent Waiting Top

Maximum number of agents that have waited.

Agents Assignment Rate

Assignment rate for agents in the last interval, which equals:

(agents_from_pool-agents_from_pool) /__interval

Increase the value of the configuration parameter agents_from_pool.

Agents Registered

Number of registered agents.

Agents Waiting on Token

Number of agents waiting on a token.

Coordination Agents Top

Maximum number of coordination agents.

Idle Agents

Number of idle agents.

Maximum Agents Registered

Maximum number of registered agents.

Maximum Coordination Agents

Maximum number of coordination agents the database has created.

Pool Agents

Number of agents from the pool.

2.2.2 Application Connection

The metrics in this category return the current connection information at both the database and database manager snapshot level, including the number of active connections.

Default Collection Interval — Every 15 minutes

Table 2-2 Application Connection Metrics

Metric Description

Active Applications

Number of active applications.

Active Local Connections

Number of active local connections.

Active Remote Connections

Number of active remote connections.

Applications Connected

Number of applications connected.

Database Name (key column)

Name of the database

Remote Connections

Current number of connections initiated from remote clients to the instance of the database manager that is being monitored.

Local Connections

Number of local applications currently connected to a database within the database instance being monitored.

Total Connections

Total number of connections.