Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. It’s a fully managed database-as-a-service offering that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability.

Use the OpsRamp Azure public cloud integration to discover and collect metrics against the Azure service.

Setup

To set up the OpsRamp Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select PostgreSQL Server.

Metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
azure_sql_database_cpu_percent

CPU percent
n/aPercentAverage
azure_memory_percent

Memory percent
n/aPercentAverage
azure_io_consumption_percent

IO percent
n/aPercentAverage
azure_sql_database_storage_percent

Storage percent
n/aPercentAverage
azure_storage_used

Storage used
n/aBytesAverage
azure_storage_limit

Storage limit
n/aBytesAverage
azure_active_connections

Active Connections
n/aCountAverage
azure_connections_failed

Failed Connections
n/aCountAverage
azure_postgresql_serverlog_storage_percent

Server Log storage percent
Server Log storage percentPercentAverage
azure_postgresql_serverlog_storage_usage

Server Log storage used
Server Log storage usedBytesAverage
azure_postgresql_serverlog_storage_limit

Server Log storage limit
Server Log storage limitBytesAverage
azure_postgresql_network_bytes_egress

Network Out across active connections
Network OutBytesTotal
azure_postgresql_network_bytes_ingress

Network In across active connections
Network InBytesTotal
azure_postgresql_pg_replica_log_delay_seconds

Replica lag in seconds
Replica LagSecondsMaximum
azure_postgresql_pg_replica_log_delay_bytes

Lag in bytes of the most lagging replica
Max Lag Across ReplicasBytesMaximum
cloud_instance_state

Express Route Status/state
Status/staten/an/a

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference