Host Template: Cloud - Azure - PostgreSQL server

Overview Copied

Azure Database for PostgreSQL provides a managed database service for app development and deployment, allowing you to create a PostgreSQL database in minutes and scale right away. Designed for app developers, Azure PostgreSQL Server allows users to focus on application management and have assurance in its high availability and trustworthy cloud platform.

This Host Template includes the following Service Checks:

Service Check Name Description Default Thresholds (Metric: Warning, Critical) UOM
Azure - PostgreSQL - Active Connections

The number of active connections currently connected to the database

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A N/A
Azure - PostgreSQL - Backup Storage Used

The average backup storage used

[Default Timespan = 30mins, Default Check Interval = 30mins]

N/A B
Azure - PostgreSQL - CPU Percent

The CPU usage of the database server

[Default Timespan = 5mins, Default Check Interval = 5mins]

cpu_percent: ​$WARNINGDT;70;85$,$CRITICALDT;90;95$

[Supports Dynamic Thresholds]

%
Azure - PostgreSQL - Connections Failed

The number of failed connection attempts to the database

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A N/A
Azure - PostgreSQL - IO Consumption Percent

The amount of I/O resources being consumed

[Default Timespan = 5mins, Default Check Interval = 5mins]

io_consumption_percent: ​$WARNINGDT;70;85$,$CRITICALDT;90;95$

[Supports Dynamic Thresholds]

%
Azure - PostgreSQL - Memory Percent

The current memory usage of the database

[Default Timespan = 5mins, Default Check Interval = 5mins]

memory_percent: ​$WARNINGDT;70;85$,$CRITICALDT;90;95$

[Supports Dynamic Thresholds]

%
Azure - PostgreSQL - Network In

The number of bytes received across active connections

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B
Azure - PostgreSQL - Network Out

The number of bytes sent across active connections

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B
Azure - PostgreSQL - Replica Lag Delay in Bytes

The maximum replica lag in bytes

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B
Azure - PostgreSQL - Replica Lag Delay in Seconds

The maximum replica lag in seconds

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A s
Azure - PostgreSQL - Server Log Storage Limit

The average server log storage limit

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B
Azure - PostgreSQL - Server Log Storage Percent

The average server log storage usage percentage

[Default Timespan = 5mins, Default Check Interval = 5mins]

serverlog_storage_percent: ​$WARNINGDT;70;85$,$CRITICALDT;90;95$

[Supports Dynamic Thresholds]

%
Azure - PostgreSQL - Server Log Storage Used

The average server log storage used

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B
Azure - PostgreSQL - Storage Limit

The limit of hard disk space the database has been allocated

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B
Azure - PostgreSQL - Storage Percent

The hard disk usage of the database

[Default Timespan = 5mins, Default Check Interval = 5mins]

storage_percent: ​$WARNINGDT;70;85$,$CRITICALDT;90;95$

[Supports Dynamic Thresholds]

%
Azure - PostgreSQL - Storage Used

The hard disk storage currently used

[Default Timespan = 5mins, Default Check Interval = 5mins]

N/A B

Note

The “Default Timespan” given for these Service Checks refers to the time period we use when retrieving metrics from Azure.

Note

See details about Nagios thresholds here.

Dynamic Thresholds Support Copied

Some Service Checks within this Host Template support Dynamic Thresholds for Opsview Enterprise.

Prerequisites for monitoring Copied

Provide Subscription Access Copied

To use this Host Template you will need to provide access to the subscription you wish to monitor. Navigate to the Subscriptions section and select your Subscription.

In the Subscription to be monitored, click Access Control (IAM).

Then click the Add button, select the required role and select the application, once for each of the following roles:

Add Subscription to Application

Add Subscription to Application

Repeat these steps for each subscription you wish to monitor.

Usage Instructions Copied

Please review the overall Cloud - Azure Opspack documentation for details on prerequisites, known issues, and other necessary configurations that apply to all Host Templates in the Opspack.

Add this Host Template Copied

Add the Cloud - Azure - PostgreSQL server Host Template to your Opsview Monitor host. If the resource you’re monitoring has no hostname or public IP, then open the Advanced settings pane and change Host Check Command to Always assumed to be UP.

Note

For more information, refer to the documentation on Adding Host Templates to Hosts.

Add and configure Variables Copied

The Service Checks in this Host Template use the following variables, and they will be added to your Opsview Monitor instance alongside the Host Template:

Note

For more information, refer to the documentation on Adding Variables to Hosts.

Apply Changes Copied

Apply Changes and the system will now be monitored:

View Output

Available Variables Copied

AZURE_CREDENTIALS Copied

The Value is not used and therefore can be set to anything. Override the arguments with your Azure Credentials.

Plugin Parameter Position in Variable Name Description
N/A (Opsview UI Only) Value Credentials The credentials for your Azure Subscription
--subscription-id Arg1 Subscription ID The Subscription ID of your Azure Subscription
--client-id Arg2 Client ID The Client ID of your Azure Subscription
--secret-key Arg3 Secret Key The Secret Key of your Azure Subscription
--tenant-id Arg4 Tenant ID The Tenant ID of your Azure Subscription

AZURE_RESOURCE_DETAILS Copied

The Value is not used and therefore can be set to anything. Override the arguments with your Azure Resource Details.

Plugin Parameter Position in Variable Name Description
N/A (Opsview UI Only) Value Resource Details The details of your Azure Resource
--resource-group Arg1 Resource Group Name of the Azure resource group of your resource
--resource-name Arg2 Resource Name Name of the Azure resource to be monitored

Plugin help Copied

Plugin: check_azure

Secure Args

This plugin uses the Secure Args feature for argument passing.

For mode-specific help, run the plugin with the -h -m <mode> flags. This will list the required and optional Variable Arguments for that mode. The appropriate mode for each Service Check is listed here:

Service Check Name Mode
Azure - PostgreSQL - Active Connections PGSQL.Active.Connections
Azure - PostgreSQL - Backup Storage Used PGSQL.Backup.Storage.Used
Azure - PostgreSQL - CPU Percent PGSQL.CPU.Percent
Azure - PostgreSQL - Connections Failed PGSQL.Connections.Failed
Azure - PostgreSQL - IO Consumption Percent PGSQL.IO.Consumption.Percent
Azure - PostgreSQL - Memory Percent PGSQL.Memory.Percent
Azure - PostgreSQL - Network In PGSQL.Network.In
Azure - PostgreSQL - Network Out PGSQL.Network.Out
Azure - PostgreSQL - Replica Lag Delay in Bytes PGSQL.Replica.Lag.Delay.B
Azure - PostgreSQL - Replica Lag Delay in Seconds PGSQL.Replica.Lag.Delay.S
Azure - PostgreSQL - Server Log Storage Limit PGSQL.Server.Log.Storage.Limit
Azure - PostgreSQL - Server Log Storage Percent PGSQL.Server.Log.Storage.Percent
Azure - PostgreSQL - Server Log Storage Used PGSQL.Server.Log.Storage.Used
Azure - PostgreSQL - Storage Limit PGSQL.Storage.Limit
Azure - PostgreSQL - Storage Percent PGSQL.Storage.Percent
Azure - PostgreSQL - Storage Used PGSQL.Storage.Used
["Opsview Cloud"] ["Opsview > Opspacks"] ["User Guide", "Technical Reference"]

Was this topic helpful?