---
title: "Host Template: Cloud - Azure - SQL Database Managed Instances (Beta)"
description: ""
url: "https://docs.itrsgroup.com/docs/opsview/6.11.7/opspacks/cloud-azure-sql-database-managed-instances-opspack/cloud-azure-sql-database-managed-instances-host-template/index.html"
---
**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](https://support.itrsgroup.com/) for more information.


## Overview

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&nbsp;Check&nbsp;Name | Description | Default&nbsp;Thresholds (Metric:&nbsp;Warning,&nbsp;Critical) | UOM |
|:-----------------------------|:------------|:------------------------------------------------:|:---:|
| Azure - SQL DB Managed Instance - CPU Percent | The average CPU percentage
[Default Timespan = 5mins, Default Check Interval = 5mins] | avg_cpu_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| 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](https://www.monitoring-plugins.org/doc/guidelines.html#THRESHOLDFORMAT).



### Dynamic Thresholds Support

Some Service Checks within this Host Template support [Dynamic Thresholds for Opsview Enterprise](https://docs.itrsgroup.com/docs/opsview/6.11.7/integrations/dynamic-thresholds/configuring-dynamic-thresholds/index.html#configure-service-checks).

## Prerequisites for monitoring

### Provide Subscription Access

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**

![Add Subscription to Application](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-add_subscription_1.png)

![Add Subscription to Application](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-add_subscription_2.png)

Repeat these steps for each subscription you wish to monitor.

## Usage Instructions

Please review the overall [Cloud - Azure - SQL Database Managed Instances Opspack (Beta)](https://docs.itrsgroup.com/docs/opsview/6.11.7/opspacks/cloud-azure-sql-database-managed-instances-opspack/cloud-azure-sql-database-managed-instances-opspack/index.html) documentation for details on prerequisites, known issues, and other necessary configurations that apply to all Host Templates in the Opspack.

### Add this Host Template

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](https://docs.itrsgroup.com/docs/opsview/6.11.7/host/index.html#host-templates).



### Add and configure Variables

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:

- [**AZURE_CREDENTIALS**](#azure_credentials)
- [**AZURE_RESOURCE_DETAILS**](#azure_resource_details)


**Note**


For more information, refer to the documentation on [Adding Variables to Hosts](https://docs.itrsgroup.com/docs/opsview/6.11.7/adding-a-new-variable/index.html#adding-a-variable-to-a-host).



### Apply Changes

Apply Changes and the system will now be monitored:

![View Output](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-sql-database-managed-instances-output-cloud-azure-sql-database-managed-instances.png)

## Available Variables

### AZURE_CREDENTIALS

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

| Plugin&nbsp;Parameter | Position&nbsp;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

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

| Plugin&nbsp;Parameter | Position&nbsp;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

Plugin: `beta_check_azure`


**Secure Args**


This plugin uses the [Secure Args](https://docs.itrsgroup.com/docs/opsview/6.11.7/configuration/secure-arguments/index.html) 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&nbsp;Check&nbsp;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` |


