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: |
% |
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: |
% |
Azure - PostgreSQL - Memory Percent | The current memory usage of the database [Default Timespan = 5mins, Default Check Interval = 5mins] |
memory_percent: |
% |
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: |
% |
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: |
% |
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 Monitoring Plugin 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:
- Reader
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:
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 |