Microsoft Azure SQL Server Database Elastic Pool API poller template

Use this template to monitor Microsoft Azure SQL Server Database Elastic Pool performance and statistics counters, including percentage utilization.

Prerequisites

• Values are provided for the following parameters:
• ${SUBSCRIPTION_ID}
• ${USERGROUP_ID}
• ${SERVER_ID}
• ${ELASTIC_POOL_ID}
• OAuth 2.0 Azure credentials are configured. See API poller authorization and authentication.

Notes

• Default thresholds are not set for this template.
• You can add the following metrics to this template:
  • xtp_storage_percent
  • cpu_limit,cpu_used
  • sqlserver_process_core_percent
  • sqlserver_process_memory_percent
  • tempdb_data_size
  • tempdb_log_size
  • tempdb_log_used_percent
  • allocated_data_storage
  • allocated_data_storage_percent
• Here is an API request example:
  https://management.azure.com/subscriptions/6a4208fe-5200-417e-9365-99781c6133c3/resourceGroups/Monitoring/providers/Microsoft.Sql/servers/jr-server/elasticPools/JR-POOL/providers/microsoft.insights/metrics?interval=PT1H&metricnames=cpu_percent,physical_data_read_percent,log_write_percent,storage_percent,workers_percent,sessions_percent,storage_limit,storage_used&aggregation=Average&api-version=2019-07-01

Available metrics

CPU percentage

The average compute utilization in percentage of the limit of the given SQL database pool during the time period specified as the polling frequency.

Unit: Percent

Data IO percentage

The average I/O utilization in percentage based on the limit of the given SQL database pool during the time period specified as the polling frequency.

Unit: Percent

Log IO percentage

The average write resource utilization in percentage of the limit of the given SQL database pool during the time period specified as the polling frequency.

Unit: Percent

Storage percent

The current average elastic pool storage used percentage for the given SQL database pool during the time period specified as the polling frequency.

Unit: Percent

Workers percent

The average concurrent workers (requests) in percentage based on the limit of the given SQL database pool during the time period specified as the polling frequency.

Unit: Percent

Sessions percent

The average concurrent sessions in percentage based on the limit of the given SQL database pool during the time period specified as the polling frequency.

Unit: Percent

Storage limit

The current average elastic pool storage limit setting for the given SQL database pool in megabytes during the time period specified as the polling frequency.

Unit: Bytes

Storage used

The average storage used by the pool, in bytes, during the time period specified as the polling frequency.

Unit: Bytes