You are here
Azure SQL DWU Monitoring
Host Template: Cloud - Azure - SQL - DWU
This host template is one of 31 developed by Opsview to provide the most comprehensive Azure monitoring in the industry.
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 Check Name | Description | Default Thresholds (Warning, Critical) | UOM |
|---|---|---|---|
| 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 - CPU Usage | The CPU usage of the data warehouse [Default Timespan = 5mins, Default Check Interval = 5mins] | cpu_percent=70,90 | % |
| Azure - SQL - DWU - Data IO Percent | The data IO percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | physical_data_read_percent=70,90 | % |
| Azure - SQL - DWU - DWU Cache Percent | The cache hit and cache used percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | cache_hit_percent=70,90 cache_used_percent=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=70,90 | % |
| 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 - Local Tempdb Percent | The local Tempdb log used percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | local_tempdb_usage_percent=70,90 | % |
| Azure - SQL - DWU - Memory Usage | The memory usage of the data warehouse [Default Timespan = 5mins, Default Check Interval = 5mins] | memory_usage_percent=70,90 | % |
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.
Usage Instructions
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.
Note:
Unlike in other Azure Host Templates, the Resource Name field (Arg2) of the 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 variable should be set to the name of the SQL Database (See 'Step 2: Add and configure variables...' below for further details).
Here the SQL Server name is shown in blue while the SQL Database name is shown in red.
Step 1: 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.
For more information, refer to Opsview Knowledge Center - Adding Host Templates to Hosts.
Step 2: Add and configure variables required for this Host Template
The Service Checks in this Host Template use the following variables, and they will be added to your Opsview Monitor instance when you import the Opspack:
AZURE_CREDENTIALS
The Value is not used and therefore can be set to anything. Override the arguments with your Azure Credentials.
| Parameter | Position in Variable | Name | Description |
|---|---|---|---|
| --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.
| Parameter | Position in Variable | Name | Description |
|---|---|---|---|
| --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.
| Parameter | Position in Variable | Name | Description |
|---|---|---|---|
| --sql-db-name | Arg1 | SQL Database Name | The name of your Azure SQL Database |
For more information, refer to Opsview Knowledge Center - Adding Variables to Hosts.
For mode-specific help, run the plugin with the -h -m
| Service Check Name | Mode |
|---|---|
| Azure - SQL - DWU - Connections | SQL.DWU.Connections |
| Azure - SQL - DWU - CPU Usage | SQL.DWU.CPU.Percent |
| Azure - SQL - DWU - Data IO Percent | SQL.DWU.Data.IO.Percent |
| 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 - Local Tempdb Percent | SQL.DWU.Tempdb |
| Azure - SQL - DWU - Memory Usage | SQL.DWU.Memory.Usage |
Step 3: Apply changes and the system will now be monitored
