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:
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. |
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. |