Azure Database for PostgreSQL - Flexible Server is a fully managed PostgreSQL database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. Develop applications with Azure Database for PostgreSQL leveraging the open-source tools and platform of your choice. Learn how to use Flexible servers with our quickstarts, tutorials, and samples.
Use OpsRamp Azure Public Cloud Integration to discover and collect metrics against Azure PostgreSQL Flexible Server.
Setup
To set up the Azure integration and discover the Target Group resources, do the following:
Create an Azure Integration if not available in your installed integrations. For more information on how to install the Azure Integration, refer to Azure Resources.
Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile.
Select
PostgreSQL Flexible Serverunder the Filter Criteria in the Edit Discovery Profile page.
Azure Integration Discovery Profile
Save the discovery profile to make them available in the list of Discovery Profiles.
Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the Target Group resources under Infrastructure > Resources > Microsoft Azure category.
Create a template with collector type Google and applicable for Interconnect. See Create a Template for more information on how to create a template.
Refer to Assign a Template on how to assign a template to a resource.
Click the Metrics tab to view the monitoring data of PostgreSQL Flexible Server as shown below:
Event support
OpsRamp supports Azure events for Azure PostgreSQL Flexible Server. Configure Azure Events in OpsRamp Azure integration discovery profile.
See Process Azure Events for more information on how to configure Azure events.
Supported metrics
| OpsRamp Metric | Metric Display Name | Unit | Description | Aggregation Type |
|---|---|---|---|---|
| azure_dbforpostgresql_flexibleservers_active_connections | Active Connections | Count | Active Connections | Average |
| azure_dbforpostgresql_flexibleservers_backup_storage_used | Backup Storage Used | Bytes | Backup Storage Used | Average |
| azure_dbforpostgresql_flexibleservers_connections_failed | Failed Connections | Count | Failed Connections | Total |
| azure_dbforpostgresql_flexibleservers_connections_succeeded | Succeeded Connections | Count | Succeeded Connections | Total |
| azure_dbforpostgresql_flexibleservers_cpu_credits_consumed | CPU Credits Consumed | Count | Total number of credits consumed by the database server | Average |
| azure_dbforpostgresql_flexibleservers_cpu_credits_remaining | CPU Credits Remaining | Count | Total number of credits available to burst. | Average |
| azure_dbforpostgresql_flexibleservers_cpu_percent | CPU percent | Present | CPU percent | Average |
| azure_dbforpostgresql_flexibleservers_disk_queue_depth | Disk Queue Depth | Count | Number of outstanding I/O operations to the data disk. | Average |
| azure_dbforpostgresql_flexibleservers_iops | IOPS | Count | IO Operations per second | Average |
| azure_dbforpostgresql_flexibleservers_maximum_used_transactionIDs | Maximum Used Transaction IDs | Count | Maximum Used Transaction IDs | Average |
| azure_dbforpostgresql_flexibleservers_memory_percent | Memory percent | Percent | Memory percent | Average |
| azure_dbforpostgresql_flexibleservers_network_bytes_egress | Network Out | Bytes | Network Out across active connections | Total |
| azure_dbforpostgresql_flexibleservers_network_bytes_ingress | Network In | Bytes | Network In across active connections | Total |
| azure_dbforpostgresql_flexibleservers_read_iops | Read IOPS | Count | Number of data disk I/O read operations per second. | Average |
| azure_dbforpostgresql_flexibleservers_read_throughput | Read Throughput Bytes/Sec | Count | Bytes read per second from the data disk during monitoring period | Average |
| azure_dbforpostgresql_flexibleservers_storage_free | Storage Free | Bytes | Storage Free | Average |
| azure_dbforpostgresql_flexibleservers_storage_percent | Storage percent | Percent | Storage percent | Average |
| azure_dbforpostgresql_flexibleservers_storage_used | Storage used | Bytes | Storage used | Average |
| azure_dbforpostgresql_flexibleservers_txlogs_storage_used | Transaction Log Storage Used | Bytes | Transaction Log Storage Used | Average |
| azure_dbforpostgresql_flexibleservers_write_iops | Write IOPS | Count | Number of data disk I/O write operations per second | Average |
| azure_dbforpostgresql_flexibleservers_write_throughput | Write Throughput Bytes/Sec | Bytes | Bytes written per second to the data disk during monitoring period. | Average |