Microsoft Azure Database for PostgreSQL Server Monitoring

• Azure Database for PostgreSQL Server - An Overview
• Creating a new Azure Database for PostgreSQL Server Monitor
• Monitored Parameters

Azure Database for PostgreSQL Server - An Overview

Azure Database for PostgreSQL server is a relational database service based on the open-source PostgreSQL database engine deployed in Microsoft Cloud. It is a fully managed relation database that provides database-as-a-service by storing and managing data in the cloud, and offers high availability, scalability, security and cost optimization. This service offers "Pay-as-you-go" pricing model based on the compute and storage resources used and helps you to independently scale them without affecting your database availability.

Applications Manager's Azure Database for PostgreSQL Server monitoring tool ensures the optimal operation of PostgreSQL databases and maintains the reliability and performance of applications relying on these databases.

Creating a new Azure Database for PostgreSQL server monitor

To learn how to create a new Azure Database for PostgreSQL server monitor, click here.

Monitored Parameters

Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the PostgreSQL Server monitor from the displayed tooltip. This action will display the bulk configuration view for Azure PostgreSQL Server in three tabs:

• Availability tab gives the availability history for the past 24 hours or 30 days.
• Performance tab gives the health status and events for the past 24 hours or 30 days.
• List view tab enables you to perform bulk admin configurations.

The Microsoft Azure monitor provides a brief detail of the Azure Database for PostgreSQL under the given subscription. Following are the list of metrics monitored in Azure Database for PostgreSQL Monitoring in their corresponding tabs:

• Overview
• Usage
• Replication
• Configuration

Overview

Parameter	Description	Server Instance Type
		Single Server	Flexible Server
SERVER INFORMATION
State	Current status of the server. Possible values are Disabled Dropping Ready Starting Stopped Stopping Updating
Fully Qualified Domain Name	Fully Qualified Domain Name (FQDN) of the server.
Resource Group Name	Name of the resource group.
Admin Username	Username of the admintrator.
Location	Location where the server resides.
Replication Role	Replication role of the server. Possible values: Master/Replica
Version	Version of the PostgreSQL server.
ACTIVE CONNECTIONS
Active Connections	The average number of active connections to the PostgreSQL server between the poll interval.
CONNECTIONS
Succeeded Connections	The total number of connections that are successfully connected to the server between the poll interval.
Failed Connections	The total number of connection that have failed to connect to the server between the poll interval.
IOPS
Total IOPS	The average number of I/O operations performed on the disk per second between the poll interval (in operations/s).
Read IOPS	The average number of I/O read operations performed on data disk per second between the poll interval (in operations/s).
Write IOPS	The average number of I/O write operations performed on data disk per second between the poll interval (in operations/s).
NETWORK THROUGHPUT
Network In	The total amount of data received from the network across active connections between the poll interval (in MB).
Network Out	The total amount of data sent to the network across active connections between the poll interval (in MB).
DISK THROUGHPUT
Read Throughput	The average rate at which data is read from disk during monitoring period between the poll interval (in kB/s).
Write Throughput	The average rate at which data is written to disk during monitoring period between the poll interval (in kB/s).
DISK QUEUE DEPTH
Disk Queue Depth	The average number of outstanding I/O operations performed on the data disk between the poll interval.

Usage

Parameter	Description	Server Instance Type
		Single Server	Flexible Server
SERVER UTILIZATION
CPU	The average amount of CPU currently in use at the time of polling (in %).
Memory	The average amount of memory currently in use at the time of polling (in %).
Storage	The average amount of storage currently in use at the time of polling (in %).
IO	The average amount of IO currently in use at the time of polling (in %). (Not applicable for Basic tier servers)
CPU CREDITS
CPU Credits Consumed	The average number of credits consumed by the database server between the poll interval.
CPU Credits Remaining	The average number of credits available to burst between the poll interval.
STORAGE
Storage Used	The average amount of storage space used by the service at the time of polling (in GB), including database files, transaction logs, and server logs.
Storage Free	The average amount of storage space available for the service at the time of polling (in GB).
BACKUP STORAGE
Backup Storage Used	The average amount of backup storage used at the time of polling (in GB), which represents the sum of storage that is consumed by all the full backups, differential backups, and log backups that are retained based on the backup retention period set for the server. The frequency of the backups is service managed. For geo-redundant storage, backup storage usage is twice the usage for locally redundant storage.
TRANSACTION LOG
Transaction Log Storage Used	The average amount of storage space used by the transaction logs at the time of polling (in GB).
Maximum Used Transaction IDs	The maximum number of transaction IDs in use between the poll interval.
SERVER LOG STORAGE
Server Log storage limit	The maximum amount of server log storage allocated for this server at the time of polling (in GB).
Server Log storage used	The average amount of server log storage used by this server at the time of polling (in GB).
Server Log storage	The average amount of server log storage used out of maximum server log storage allocated for this server at the time of polling (in %).

Replication

Parameter	Description	Server Instance Type
		Single Server	Flexible Server
MAX LAG ACROSS REPLICAS
Max Lag Across Replicas	The maximum lag between the primary and the most-lagging replica between the poll interval (in kB).
REPLICA LAG
Replica Lag	The maximum time elapsed since the last replayed transaction between the polling interval (in seconds).

Configuration

Parameter	Description	Server Instance Type
		Single Server	Flexible Server
CONFIGURATION
Minimal TLS Version	Minimal TLS version enforced for the server.
SSL Enforcement	Indicates whether SSL enforcement is performed while connecting to the server.
Replica Capacity	The maximum number of replicas that a master server can have.
Server Type	Type of the resource server. Possible Values: Single/Flexible.
Created At	Timestamp at which the resource server was created.
BACKUP
Backup Retention Period	Time period for which backup data is retained for the server (in days).
Geo Redundant Backup	Indicates whether Geo redundancy is configured for server backup.
Storage AutoGrow	Indicates whether AutoGrow is configured for the server. Possble values: Enabled/Disabled
Earliest Restore Date	Timestamp of the earliest restore point creation.
HIGH AVAILABILITY
Mode	High Availability (HA) mode of the server. Possible values: Disabled SameZone ZoneRedundant
High Availability State	State of the High Availability (HA) mode for the server.
Standby Availability Zone	Availability zone information of the standby server.
NETWORK
Public Network Access	Indicates whether public network access is allowed for the server.
Delegated Subnet Resource ID	Reource ID of the delegated subnet.
Private DNS Zone ARM Resource ID	Resource ID of the Private DNS zone.
SKU
SKU	The name of the SKU, displayed in the format <tier>_<family>_<cores>. Eg. B_Gen4_1, GP_Gen5_8.
Tier	The tier of the particular SKU. Possible values: Basic GeneralPurpose MemoryOptimized
Family	The family of hardware used.
Capacity	The scale up/out capacity, representing server's compute units.