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 TypeDescription
azure_sql_database_cpu_percentn/aPercentAverageCPU percent
azure_memory_percentn/aPercentAverageMemory percent
azure_io_consumption_percentn/aPercentAverageIO percent
azure_sql_database_storage_percentn/aPercentAverageStorage percent
azure_storage_usedn/aBytesAverageStorage used
azure_storage_limitn/aBytesAverageStorage limit
azure_active_connectionsn/aCountAverageActive Connections
azure_connections_failedn/aCountAverageFailed Connections
azure_postgresql_serverlog_storage_percentServer Log storage percentPercentAverageServer Log storage percent
azure_postgresql_serverlog_storage_usageServer Log storage usedBytesAverageServer Log storage used
azure_postgresql_serverlog_storage_limitServer Log storage limitBytesAverageServer Log storage limit
azure_postgresql_network_bytes_egressNetwork OutBytesTotalNetwork Out across active connections
azure_postgresql_network_bytes_ingressNetwork InBytesTotalNetwork In across active connections
azure_postgresql_pg_replica_log_delay_secondsReplica LagSecondsMaximumReplica lag in seconds
azure_postgresql_pg_replica_log_delay_bytesMax Lag Across ReplicasBytesMaximumLag in bytes of the most lagging replica
cloud_instance_stateStatus/staten/an/aExpress Route Status/state

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference