Azure Database for PostgreSQL

Microsoft Azure Database services provide fully managed relational, NoSQL, and in-memory databases with automated infrastructure management. Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine.

In Cisco Cloud Observability, Azure Database for PostgreSQL is categorized as a database instance, or a collection of databases. For the PostgreSQL database, a database instance entity represents the Azure Database in PostgreSQL.

You must configure cloud connections to monitor this entity. See Configure Azure Cloud Connection. For detailed visibility, such as query profiling and streamlined troubleshooting, install Database Monitoring.

Cisco Cloud Observability displays Azure entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.

This document contains references to third-party documentation. Splunk AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.

Detail View

To display the detail view for an Azure Database for PostgreSQL entity:

Navigate to the Observe page.
Under Database & Storage, click SQL Database Instances.
The list view now displays.
Click the Azure button to display only Azure database entities.
From the list, click a database Name to display the detail view.
The detail view displays metrics, key performance indicators, and properties (attributes) related to the database you selected.

Metrics and Key Performance Indicators

Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for Azure Database for PostgreSQL. See Supported metrics for Microsoft.DBforPostgreSQL/flexibleServers.

Display Name	Source Metric	Description
CPU Utilization (%)	`cpu_percent`	The percentage of used CPU.
Active Connections (Count)	`active_connections`	The number of active connections.
Failed Connections (Count)	`connections_failed`	The number of failed connections.
Memory Utilization (%)	`memory_percent`	The percentage of used memory.
IO Utilization (%)	`io_consumption_percent`	The percentage of used IO.
Storage Utilization (%)	`storage_percent`	The percentage of used storage.
Network In Across Active Connections (Bytes)	`network_bytes_ingress`	The network in across active connections in bytes.
Network Out Across Active Connections (Bytes)	`network_bytes_egress`	The network out across active connections in bytes.
Server Log Storage (%)	`serverlog_storage_percent`	The percentage of used server log storage.
CPU Credits Remaining (Count)	`cpu_credits_remaining`	The total number of credits available to burst. Only applicable to Postgre flexibleServers.
CPU Credits Consumed (Count)	`cpu_credits_consumed`	The total number of credits consumed by the database server. Only applicable to Postgre flexibleServers.
Disk Queue Depth (Count)	`disk_queue_depth`	The number of outstanding I/O operations to the data disk. Only applicable to Postgre flexibleServers.
Read IOPS (Count)	`read_iops`	The number of data disk I/O read operations per second. Only applicable to Postgre flexibleServers.
Write IOPS (Count)	`write_iops`	The number of data disk I/O write operations per second. Only applicable to Postgre flexibleServers.

Properties (Attributes)

Cisco Cloud Observability displays the following properties for Azure Database for PostgreSQL.

Display Name	Property Name	Description
Resource Group	`resourceGroup`	The resource group of the database.
ID	`id`	The resource ID of the database.
Cloud Account ID	`accountId`	The cloud account ID the resource is assigned to.
Availability Zones	`zones`	The availability zone where the database is present.
Location	`location`	The location of the database.
Cloud Service	`platform`	The Azure service that the resource belongs to.

Retention and Purge Time-To-Live (TTL)

For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).

Microsoft Azure, the Microsoft Azure logo, Azure, and any other Microsoft Azure Marks used in these materials are trademarks of Microsoft Corporation or its affiliates in the United States and/or other countries.