You are here
Azure Elastic Pool Monitoring
Host Template: Cloud - Azure - Elastic Pool
This host template is one of 31 developed by Opsview to provide the most comprehensive Azure monitoring in the industry.
The Elastic database features of Azure SQL Database are designed to simplify data tier development and management, especially for Software as a Service (SaaS) developers, where large numbers of databases are used to support a dynamic end-customer base.
This Host Template includes the following Service Checks:
| Service Check Name | Description | Default Thresholds (Warning, Critical) | UOM |
|---|---|---|---|
| Azure - EP - Allocated Storage | The allocated data storage [Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - EP - Allocated Storage Percent | The percentage of storage allocated [Default Timespan = 5mins, Default Check Interval = 5mins] | allocated_data_storage_percent=70,90 | % |
| Azure - EP - CPU Usage | The percentage of CPU being used [Default Timespan = 5mins, Default Check Interval = 5mins] | cpu_percent=70,90 | % |
| Azure - EP - CPU Used | The CPU limit and number of CPUs used for the elastic pool [Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | N/A |
| Azure - EP - Data IO Percent | The data IO percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | physical_data_read_percent=70,90 | % |
| Azure - EP - eDTU Usage Percent | The eDTU percentage used for the elastic pool [Default Timespan = 5mins, Default Check Interval = 5mins] | edtu_usage_percent=70,90 | % |
| Azure - EP - eDTU Used | The eDTU limit and eDTU used for the elastic pool [Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | N/A |
| Azure - EP - Log IO Percent | The log IO percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | log_write_percent=70,90 | % |
| Azure - EP - Process CPU Usage | CPU usage of the SQL DB process as a percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | sqlserver_process_core_percent=70,90 | % |
| Azure - EP - Process Memory Usage | Memory usage of the SQL DB process as a percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | sqlserver_process_memory_percent=70,90 | % |
| Azure - EP - Sessions Percent | The percentage of sessions used [Default Timespan = 5mins, Default Check Interval = 5mins] | sessions_percent=70,90 | % |
| Azure - EP - Storage Usage | The percentage of storage used [Default Timespan = 5mins, Default Check Interval = 5mins] | storage_percent=70,90 | % |
| Azure - EP - Storage Used | The amount of data space used [Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - EP - Tempdb Percent | The Tempdb log used percentage [Default Timespan = 5mins, Default Check Interval = 5mins] | tempdb_log_used_percent=70,90 | % |
| Azure - EP - Tempdb Used | The Tempdb data size and log size [Default Timespan = 5mins, Default Check Interval = 5mins] | N/A | B |
| Azure - EP - Workers Percent | The percentage of workers [Default Timespan = 5mins, Default Check Interval = 5mins] | workers_percent=70,90 | % |
| Azure - EP - XTP Storage Percent | The percentage of XTP (in-memory OLTP) storage used [Default Timespan = 5mins, Default Check Interval = 5mins] | xtp_storage_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:
1. 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 Elastic Pool Name field (Arg1) of the AZURE_EP_SETTINGS variable should be set to the name of the Elastic Pool (See 'Step 2: Add and configure variables...' below for further details).
Here the SQL Server name is shown in red while the Elastic Pool name is shown in blue.
2. The following Service Checks will return UNKNOWN if they are not applicable to your Elastic Pool type:
- Azure - EP - CPU Used: only supports vCore-based Elastic Pools.
- Azure - EP - eDTU Usage Percent: only supports DTU-based Elastic Pools.
- Azure - EP - eDTU Used: only supports DTU-based Elastic Pools.
Use the Elastic Pool Type field (Arg2) of the AZURE_EP_SETTINGS variable to specify the Elastic Pool type.
Step 1: Add this Host Template
Add the Cloud - Azure - SQL - Elastic Pool 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_EP_SETTINGS
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 |
|---|---|---|---|
| --ep-name | Arg1 | Elastic Pool Name | The name of your Azure Elastic Pool |
| --ep-type | Arg2 | Elastic Pool Type | The type of your Azure Elastic Pool (valid types are 'DTU' or 'vCore', defaults to 'DTU') |
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 - EP - Allocated Storage | EP.Allocated.Storage |
| Azure - EP - Allocated Storage Percent | EP.Allocated.Percent |
| Azure - EP - CPU Usage | EP.CPU.Percent |
| Azure - EP - CPU Used | EP.CPU.Used |
| Azure - EP - Data IO Percent | EP.Data.IO.Percent |
| Azure - EP - eDTU Usage Percent | EP.eDTU.Usage.Percent |
| Azure - EP - eDTU Used | EP.eDTU.Used |
| Azure - EP - Log IO Percent | EP.Log.Io.Percent |
| Azure - EP - Process CPU Usage | EP.CPU.Usage |
| Azure - EP - Process Memory Usage | EP.Memory.Percent |
| Azure - EP - Sessions Percent | EP.Sessions.Percent |
| Azure - EP - Storage Usage | EP.Storage.Usage |
| Azure - EP - Storage Used | EP.Storage.Used |
| Azure - EP - Tempdb Percent | EP.Tempdb.Percent |
| Azure - EP - Tempdb Used | EP.Tempdb.Used |
| Azure - EP - Workers Percent | EP.Workers.Percent |
| Azure - EP - XTP Storage Percent | EP.XTP.Storage.Percent |
Step 3: Apply changes and the system will now be monitored
