Tuning the maximum connections in the database - BMC PATROL for PostgreSQL Database 1.0

Number of connections

Set the threshold on this attribute to get notified about the number of connections to the PostgreSQL database. By default, this attribute will not generate an alarm or warning event. For more information about this attribute, see Number of Connections attribute page.

For more information about setting an alarm or warning event for this attribute, or changing the default attribute range, see Defining a monitoring policy.

Number of connections graph

Event generated by the KM

You can see the event in the TrueSight console in Monitoring > Events.

Suggested action

The KM event indicates that you might want to increase the number of maximum connections in the PostgreSQL database.

Number of elements waiting to get a lock

Set the threshold on this attribute to get notified about the number of database elements waiting to get a lock. By default, this attribute will not generate an alarm or warning event. For more information about this attribute, see Number of elements waiting to get a Lock attribute page.

For more information about setting an alarm or warning event for this attribute, or changing the default attribute range, see Defining a monitoring policy.

Number of elements waiting to get a lock graph

Event generated by the KM

You can see the event in the TrueSight console in Monitoring > Events.

Suggested action

The KM event indicates that you might want to increase the maximum connections in the PostgreSQL database so fewer elements (connections) are waiting for a lock.

Number of locked database elements

Set the threshold on this attribute to get notified  about the number of locked database elements. By default, this attribute will not generate an alarm or warning event. For more information about this attribute, see Number of locked elements attribute page.

For more information about setting an alarm or warning event for this attribute, or changing the default attribute range, see Defining a monitoring policy.

Number of elements that acquire locks graph


Event generated by the KM

You can see the event in the TrueSight console in Monitoring > Events.

Suggested action

The KM event indicates that you might want to increase the number of maximum connections in the PostgreSQL database so more elements (connections) are locked.

You Might Also Like