Cloud - Azure - SQL Database Managed Instances Opspack (Beta)
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 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 Copied
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 Copied
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 Template | Description |
|---|---|
| Cloud - Azure - SQL Database Managed Instances | (Beta) Monitor the status of your Azure Managed SQL Database Instances |
Setup Microsoft Azure for Monitoring Copied
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 Copied
The Subscription ID can be found in the Subscriptions section under the General section of the All services menu in the Azure dashboard.
Find the Tenant/Directory ID Copied
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 the Client/Application ID for your application Copied
You need to create and register your application if you haven’t already. For more information, refer to: 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.
Generate the Secret Key for your application Copied
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.
Find the Resource Group Copied
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 your Resource Name Copied
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.
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.
