Azure Database for PostgreSQL Monitoring Integration

Azure Database for PostgreSQL is a fully managed database service that includes features like high availability and intelligence. With no upfront expenditures, you can continue to utilize the languages and frameworks of your choice.

With Site24x7's integration, you can now monitor your Azure Database for PostgreSQL, configure thresholds, and receive alerts about critical issues.

Setup and configuration

You can add Azure Database for PostgreSQL while adding a new monitor, or you can add it to an existing Azure monitor. Follow these steps to add the service.

Supported metrics

The following metrics are collected:

Metric name	Description	Statistic	Unit
Active Connections	The number of active connections	Average	Count
Backup Storage Used	The used backup storage	Average	Bytes
Failed Connections	The number of failed connections	Total	Count
CPU Percent	The percentage of CPU utilized	Average	Percent
IO Percent	The percentage of time used for input/output operations	Average	Percent
Memory Percent	The percentage of memory used	Average	Percent
Network Out	The total network out across the active connections	Total	Bytes
Network In	The total network in across the active connections	Total	Bytes
Max Lag Across Replicas	The amount of lag in the most lagging replica	Maximum	Bytes
Replica Lag	The cost of delay in the replica	Maximum	Seconds
Server Log Storage Limit	The maximum server log storage for the server	Maximum	Bytes
Server Log Storage Percent	The percentage of server log storage used	Average	Percent
Server Log Storage Used	The amount of server log storage in use	Average	Bytes
Storage Limit	The maximum storage for the server	Maximum	Bytes
Storage Percent	The percentage of storage used	Average	Percent
Storage Used	The amount of storage in use	Average	Bytes

Threshold configuration

Global configuration

Go to the Admin section in the left navigation pane.
Select Configuration Profiles from the left pane and choose the Threshold and Availability (+) tab from the drop-down menu. Click Add Threshold Profile from the top-right corner.
Set the monitor type as Azure Database for PostgreSQL. You can now set the threshold values for all the metrics mentioned above.

Monitor-level configuration

Go to Cloud > Azure and select Azure Database for PostgreSQL from the drop-down menu.
Choose a resource for which you would like to set a threshold, then click the hamburger icon . Select Edit, which will direct you to the Edit Azure Database for PostgreSQL Monitor page.
You can set the threshold values for the metrics by selecting Threshold and Availability. You can also configure IT Automation at the attribute level.

IT Automation

Site24x7 offers a set of exclusive IT Automation tools to auto-resolve performance degradation issues. These tools react to events proactively rather than waiting for manual intervention.

How to configure IT Automation for a monitor

Configuration Rules

With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors.

How to add Configuration Rules