---
title: "Cloud - Azure - SQL Database Managed Instances Opspack (Beta)"
description: ""
url: "https://docs.itrsgroup.com/docs/opsview/6.11.6/opspacks/cloud-azure-sql-database-managed-instances-opspack/cloud-azure-sql-database-managed-instances-opspack/index.html"
---
**Beta Software**


Please note that this Opspack 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 Opspack may not be present on installation of Opsview Monitor but can be requested. Please contact
[ITRS Support](https://support.itrsgroup.com/) for more information.


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.

## What You Can Monitor

This Opspack 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.

## Host Templates

The following Host Templates are currently provided by this BETA Opspack.
Click the name of each Host Template to be taken to the relevant information page, including a full Service Check description and usage instructions.

| Host&nbsp;Template | Description |
|:-------------------|:------------|
| [Cloud - Azure - SQL Database Managed Instances](/opspacks/cloud-azure-sql-database-managed-instances-opspack/cloud-azure-sql-database-managed-instances-host-template/ "Host Template: Cloud - Azure - SQL Database Managed Instances") | **(Beta)** Monitor the status of your Azure Managed SQL Database Instances |

## Setup Microsoft Azure for Monitoring

To monitor your Azure environment, you need to configure it for monitoring. This requires Administrator access on Azure.

 You need to retrieve the following credentials, which will allow Opsview Monitor access to the metrics provided by Azure:

- Subscription ID
- Tenant/Directory ID
- Client/Application ID
- Secret Key

 Follow the steps below to retrieve this information.

### Find the Subscription ID

 The Subscription ID can be found in the **Subscriptions** section under the **General** section of the **All services** menu in the Azure dashboard.

 ![Find Azure Subscription ID](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_subscription_id_1.png)

 ![Find Azure Subscription ID](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_subscription_id_2.png)

### Find the Tenant/Directory ID

 Navigate to the **Security** section under **All services** in the Azure dashboard. The Tenant/Directory ID can then be found in the **Azure Active Directory** menu in the **Properties** section.

 ![Find Azure Tenant/Directory ID](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_directory_id_1.png)

 ![Find Azure Tenant/Directory ID](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_directory_id_2.png)

### Find the Client/Application ID for your application

 You need to create and register your application if you haven't already. For more information, refer to: [Create an Azure Active Directory application](https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-create-service-principal-portal#create-an-azure-active-directory-application)

 Navigate to the **Security** section under **All services** in the Azure dashboard. The Client/Application ID can be found in the **Azure Active Directory** menu under the **App registrations** section in the Azure dashboard.

 ![Find Azure Client/Application ID](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_application_id_1.png)

 ![Find Azure Client/Application ID](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_application_id_2.png)

### Generate the Secret Key for your application

 You will need to create a Secret Key for your application, once this has been created its value will be hidden, so save the value during creation.

 To create the Secret Key, select your application from the list, select the **Certificates and secrets** section and then click on **New client secret**.

 Specify a description and expiration date for your key and then click **Add**.

 ![Create Secret Key](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-create_secret_key.png)

### Find the Resource Group

You will need the name of your Resource Group in order to monitor the resources inside of it.
The Resource Groups can be found in the **Resource Groups** section, found in **All services**. Here we can find the names of Resource Groups that we have already created or create new ones.

 ![Find Resource Group](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_resource_group_1.png)

 ![Find Resource Group](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_resource_group_2.png)

### Find your Resource Name

You will need the name your Resource in order to monitor it.
The Resources can be found in the **All resources** section, found in **All services**. Here we can find the names of the Resources that we have already created or create new ones.

 ![Find Resources](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_resources_1.png)

 Here you can see 3 different Resources with their names highlighted. Note that we don't require the details in the brackets that follow certain resources.
 ![Find Resources](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-find_resources_2.png)


