Host Template: Cloud - Azure - SQL Database Managed Instances (Beta)

Beta Software

Please note that this Host Template has been made available as early release beta software and is not officially supported for production use. These Beta releases are provided on an ‘as is’ and ‘as available’ basis. Opsview does not give any warranties, whether express or implied, as to the suitability or usability of these releases.

Opsview will not be liable for any loss, whether such loss is direct, indirect, special or consequential, suffered by any party as a result of the use of any of these Beta releases.

This Host Template may not be present on installation of Opsview Monitor but can be requested. Please contact ITRS Support for more information.

Overview Copied

Managed instances are a new deployment method for Azure SQL Databases. They are fully compatible with the latest on-premise SQL Server version and provide a native virtual network implementation. The managed instance deployment model is designed to allow customers to migrate their existing on-premise applications to fully managed PaaS cloud environment with as minimal migration effort as possible. Managed instances provide all the benefits of a PaaS system, such as automatic patching, version updates, automatic backups and high availability, and therefore reduce the management overhead.

This Host Template allows you to monitor the status of your managed SQL database instances. After installation, you’ll be able to check the virtual core count, CPU usage, storage usage, as well as IO statistics.

This Host Template includes the following Service Checks:

Service Check Name Description Default Thresholds (Metric: Warning, Critical) UOM
Azure - SQL DB Managed Instance - CPU Percent

The average CPU percentage

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

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

[Supports Dynamic Thresholds]

%
Azure - SQL DB Managed Instance - IO Bytes

The number of IO bytes read/written

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

N/A B
Azure - SQL DB Managed Instance - IO Requests

The number of IO requests

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

N/A N/A
Azure - SQL DB Managed Instance - Storage Space Reserved

The reserved storage space

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

N/A MB
Azure - SQL DB Managed Instance - Storage Space Used

The used storage space

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

N/A MB
Azure - SQL DB Managed Instance - Virtual Core Count

The virtual core count

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

N/A N/A

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 - SQL Database Managed Instances Opspack (Beta) 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 - SQL Database Managed Instances 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

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 - SQL DB Managed Instance - CPU Percent Az.Sql.Mgd.Db.CPU.Percent
Azure - SQL DB Managed Instance - IO Bytes Az.Sql.Mgd.Db.IO.Bytes
Azure - SQL DB Managed Instance - IO Requests Az.Sql.Mgd.Db.IO.Requests
Azure - SQL DB Managed Instance - Storage Space Reserved Az.Sql.Mgd.Db.Storage.Space.Reserved
Azure - SQL DB Managed Instance - Storage Space Used Az.Sql.Mgd.Db.Storage.Space.Used
Azure - SQL DB Managed Instance - Virtual Core Count Az.Sql.Mgd.Db.Virtual.Core
["Opsview On-Premises"] ["Opsview > Opspacks"] ["User Guide", "Technical Reference"]

Was this topic helpful?