Host Template: Cloud - Azure - MySQL Server

Overview Copied

SQL Azure is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases.

This Host Template includes the following Service Checks:

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

The average number of active connections

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

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

The average backup storage usage

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

N/A B
Azure - MySQL - CPU Percent

The CPU usage

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

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

[Supports Dynamic Thresholds]

%
Azure - MySQL - Connections Failed

The the number of failed connections

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

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

The average IO consumption

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

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

[Supports Dynamic Thresholds]

%
Azure - MySQL - Memory Percent

The memory usage

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

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

[Supports Dynamic Thresholds]

%
Azure - MySQL - Network In

The number of bytes received across active connections

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

N/A B
Azure - MySQL - Network Out

The number of bytes sent across active connections

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

N/A B
Azure - MySQL - Replication Lag

The average replication lag in seconds

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

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

The average server log storage limit

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

N/A B
Azure - MySQL - 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 - MySQL - Server Log Storage Used

The average server log storage usage

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

N/A B
Azure - MySQL - Storage Limit

The average storage limit

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

N/A B
Azure - MySQL - Storage Percent

The storage usage

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

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

[Supports Dynamic Thresholds]

%
Azure - MySQL - Storage Used

The storage usage in bytes

[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:

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 - MySQL 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 - MySQL - Active Connections MYSQL.Active.Connections
Azure - MySQL - Backup Storage Used MYSQL.Backup.Storage.Used
Azure - MySQL - CPU Percent MYSQL.CPU.Percent
Azure - MySQL - Connections Failed MYSQL.Connections.Failed
Azure - MySQL - IO Consumption Percent MYSQL.IO.Consumption.Percent
Azure - MySQL - Memory Percent MYSQL.Memory.Percent
Azure - MySQL - Network In MYSQL.Network.In
Azure - MySQL - Network Out MYSQL.Network.Out
Azure - MySQL - Replication Lag MYSQL.Replication.Lag
Azure - MySQL - Server Log Storage Limit MYSQL.Server.Log.Storage.Limit
Azure - MySQL - Server Log Storage Percent MYSQL.Server.Log.Storage.Percent
Azure - MySQL - Server Log Storage Used MYSQL.Server.Log.Storage.Used
Azure - MySQL - Storage Limit MYSQL.Storage.Limit
Azure - MySQL - Storage Percent MYSQL.Storage.Percent
Azure - MySQL - Storage Used MYSQL.Storage.Used
["Opsview On-Premises"] ["Opsview > Opspacks"] ["User Guide", "Technical Reference"]

Was this topic helpful?