You are here

Azure Elastic Pool Monitoring

Requires Opsview Cloud or Opsview Monitor 6
check_circle
Opsview Supported

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, Granularity = 5mins] N/A B
Azure - EP - Allocated Storage Percent The percentage of storage allocated [Default Timespan = 5mins, Granularity = 5mins] allocated_data_storage_percent=70,90 %
Azure - EP - CPU Usage The percentage of CPU being used [Default Timespan = 5mins, Granularity = 5mins] cpu_percent=70,90 %
Azure - EP - CPU Used The CPU limit and number of CPUs used for the elastic pool [Default Timespan = 5mins, Granularity = 5mins] N/A N/A
Azure - EP - Data IO Percent The data IO percentage [Default Timespan = 5mins, Granularity = 5mins] physical_data_read_percent=70,90 %
Azure - EP - eDTU Usage Percent The eDTU percentage used for the elastic pool [Default Timespan = 5mins, Granularity = 5mins] edtu_usage_percent=70,90 %
Azure - EP - eDTU Used The eDTU limit and eDTU used for the elastic pool [Default Timespan = 5mins, Granularity = 5mins] N/A N/A
Azure - EP - Log IO Percent The log IO percentage [Default Timespan = 5mins, Granularity = 5mins] log_write_percent=70,90 %
Azure - EP - Process CPU Usage CPU usage of the SQL DB process as a percentage [Default Timespan = 5mins, Granularity = 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, Granularity = 5mins] sqlserver_process_memory_percent=70,90 %
Azure - EP - Sessions Percent The percentage of sessions used [Default Timespan = 5mins, Granularity = 5mins] sessions_percent=70,90 %
Azure - EP - Storage Usage The percentage of storage used [Default Timespan = 5mins, Granularity = 5mins] storage_percent=70,90 %
Azure - EP - Storage Used The amount of data space used [Default Timespan = 5mins, Granularity = 5mins] N/A B
Azure - EP - Tempdb Percent The Tempdb log used percentage [Default Timespan = 5mins, Granularity = 5mins] tempdb_log_used_percent=70,90 %
Azure - EP - Tempdb Used The Tempdb data size and log size [Default Timespan = 5mins, Granularity = 5mins] N/A B
Azure - EP - Workers Percent The percentage of workers [Default Timespan = 5mins, Granularity = 5mins] workers_percent=70,90 %
Azure - EP - XTP Storage Percent The percentage of XTP (in-memory OLTP) storage used [Default Timespan = 5mins, Granularity = 5mins] xtp_storage_percent=70,90 %

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

Azure Add Subscription Step 1

Azure Add Subscription Step 2

Repeat these steps for each subscription you wish to monitor.

Note:
1. As part of an upgrade, any host that has the old Cloud - Azure - SQL Host Template will default to the new Cloud - Azure - SQL - Elastic Pool Host Template. This may not be the correct Host Template for your SQL database so you will need to manually verify and change the Host Template as required.

2. Unlike in other Azure Host Templates, the Resource Name field of the AZURE_RESOURCE_DETAILS variable is the name of the SQL Server while the Value field of the AZURE_SQL_DATABASE_DETAILS variable is the name of the SQL Database.

Variable Azure Resource Details

Here the value for the Resource Name of AZURE_RESOURCE_DETAILS is shown in blue while the Value for the AZURE_SQL_DATABASE_DETAILS is shown in red.

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 (DTU or vCore)

For more information, refer to Opsview Knowledge Center - Adding Variables to Hosts.

For mode-specific help, run the plugin with the -h -m 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 - 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

Azure Elastic Pool Output