---
title: "Host Template: Cloud - Azure - SQL - DWU"
description: ""
url: "https://docs.itrsgroup.com/docs/opsview/6.11.7/opspacks/cloud-azure-opspack/cloud-azure-sql-dwu-host-template/index.html"
---## Overview

Azure SQL Database is a cloud database service from Microsoft. SQL Database provides web-facing database functionality as a utility service where you pay only for what you use. Cloud-based database solutions such as SQL Database provide many benefits such as rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. This Host Template only applies to Azure Synapse Analytics (formerly SQL Data Warehouses).

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 - DWU - CPU Usage | The CPU usage of the data warehouse
[Default Timespan = 5mins, Default Check Interval = 5mins] | cpu_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - SQL - DWU - Connections | The number of successful, failed and blocked connections
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | N/A |
| Azure - SQL - DWU - DWU Cache Percent | The cache hit and cache used percentage
[Default Timespan = 5mins, Default Check Interval = 5mins] | cache_hit_percent: &#8203;`70`,`90`
cache_used_percent: &#8203;`70`,`90` | % |
| Azure - SQL - DWU - DWU Usage Percent | The DWU consumption usage of the data warehouse
[Default Timespan = 5mins, Default Check Interval = 5mins] | dwu_consumption_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - SQL - DWU - DWU Used | The DWU limit and number of DWUs used
[Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | N/A |
| Azure - SQL - DWU - Data IO Percent | The data IO percentage
[Default Timespan = 5mins, Default Check Interval = 5mins] | physical_data_read_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - SQL - DWU - Local Tempdb Percent | The local Tempdb log used percentage
[Default Timespan = 5mins, Default Check Interval = 5mins] | local_tempdb_usage_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |
| Azure - SQL - DWU - Memory Usage | The memory usage of the data warehouse
[Default Timespan = 5mins, Default Check Interval = 5mins] | memory_usage_percent: &#8203;`$WARNINGDT;70;85$`,`$CRITICALDT;90;95$`
[[Supports Dynamic Thresholds]](#dynamic-thresholds-support) | % |


**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 Opspack](https://docs.itrsgroup.com/docs/opsview/6.11.7/opspacks/cloud-azure-opspack/cloud-azure-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 - DWU** 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)
- [**AZURE_SQL_DATABASE_DETAILS**](#azure_sql_database_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-output-cloud-azure-sql-dwu.png)

## Additional Information

**Note:**

Unlike in other Azure Host Templates, the **Resource Name** field (Arg2) of the [**AZURE_RESOURCE_DETAILS**](#azure_resource_details) variable should be set to the name of the **SQL server** while the **SQL Database Name** field (Arg1) of the [**AZURE_SQL_DATABASE_DETAILS**](#azure_sql_database_details) variable should be set to the name of the **SQL Database** (See 'Add and configure variables' for further details).

![Host Variable Details](https://docscdn.itrsgroup.com/opsview/images/opspacks-cloud-azure-variable-AZURE_RESOURCE_DETAILS-cloud-azure-sql.png)

Here the **SQL Server** name is shown in **blue** while the **SQL Database** name is shown in **red**.

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

### AZURE_SQL_DATABASE_DETAILS

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

| Plugin&nbsp;Parameter | Position&nbsp;in Variable | Name | Description |
|:---------------------:|:-------------------------:|:-----|:------------|
| N/A (Opsview UI Only) | Value | SQL Database Details | The details of your Azure SQL Database |
| `--sql-db-name` | Arg1 | SQL Database Name | The name of your Azure SQL Database |

## Plugin help

Plugin: `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 - DWU - CPU Usage | `SQL.DWU.CPU.Percent` |
| Azure - SQL - DWU - Connections | `SQL.DWU.Connections` |
| Azure - SQL - DWU - DWU Cache Percent | `SQL.DWU.Cache.Percent` |
| Azure - SQL - DWU - DWU Usage Percent | `SQL.DWU.Usage.Percent` |
| Azure - SQL - DWU - DWU Used | `SQL.DWU.Used` |
| Azure - SQL - DWU - Data IO Percent | `SQL.DWU.Data.IO.Percent` |
| Azure - SQL - DWU - Local Tempdb Percent | `SQL.DWU.Tempdb` |
| Azure - SQL - DWU - Memory Usage | `SQL.DWU.Memory.Usage` |


