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: |
% |
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 Nagios 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:
- Reader
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:
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: beta_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 - 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 |