Microsoft Azure SQL Database Elastic Pool

This template contains performance and statistics counters to monitor SQL Database Elastic Pools.

Prerequisites

  • PowerShell 5.0 or later is installed on the system where the template will run.
  • PowerShell module (Azure, AzureRM) is installed on the system where the template will run.

    To install the Azure module, execute these PowerShell commands:

    • Install-Module -Name Azure
    • Install-Module -Name AzureRM
  • To connect with the Azure account, the following parameters are required:
    • subscriptionID
    • ApplicationID
    • TenantID
    • Secret Key
    • Application Name: Any Azure App (with name and ID) with Contributor or Reader role in Azure role-based access control (RBAC).
  • SQL Server Database Elastic Pool name for which metrics are being calculated.

Credentials

  • Login credentials for the Azure Portal, passed as script arguments per prerequisites.
    For example, <SubscriptionID>, <TenantID>, <ApplicationID>, value=<Secret Key>, <SQL Server Database Name>).
  • Optional parameters can be passed to script argument:
    • value=<Time Interval> - during which data must be fetched, in minutes. The default is 10 minutes.
    • Number of retries as the second last argument; the default is 3.
    • WaitTime as the last argument; the default is 0.5 seconds

Notes

Component Monitors

CPU percentage

This metric provides 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

DTU percentage

This monitor provides the average eDTU utilization in percentage of eDTU limit of the given SQL database pool during the time period specified as the Polling Frequency.

Unit: Percent

eDTU (Database Throughput Unit) limit

This metric provides the current average elastic pool DTU setting for the given SQL database pool during the time period specified as the Polling Frequency.

Unit: Count

eDTU (Database Throughput Unit) used

This metric provides the average eDTUs used by the given SQL database pool during the time period specified as the Polling Frequency.

Unit: Count

Log IO percentage

This metric provides 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

Data IO percentage

This metric provides 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

Sessions percentage

This metric provides 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

This metric provides 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 percentage

This metric provides 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

Storage used

This metric provides the average storage used by the pool in bytes during the time period specified as the polling frequency.

Unit: Bytes

Workers percentage

This metric provides 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