Microsoft Azure SQL Database

This template contains performance and statistics counters for monitoring an Azure SQL Database.

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).
  • The SQL Server database name for which metrics are being calculated.
  • Time interval for which data has to be fetched, in hours.

Credentials

  • Login credentials for the Azure Portal, passed as script arguments per prerequisites (<subscriptionID>, <TenantID>, <ApplicationID>, value=<Secret Key>, <SQL Server Database Name>).
  • Windows Admin rights on the target system.
  • 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

Blocked Connections

This metric provides the average number of firewall blocked connections established for the given SQL database during the time period specified as the Polling Frequency.

Unit: Count

Failed Connections

This monitor provides the average number of failed connections established for the given SQL database during the time period specified as the Polling Frequency.

Unit: Count

Successful Connections

This metric provides the average number of successful connections established for the given SQL database during the time period specified as the Polling Frequency.

Unit: Count

Deadlocks

This metric provides the average number of deadlocks established for the given SQL database during the time period specified as the Polling Frequency.

Unit: Count

Database throughput units (DTU) Limit

This metric provides the average database throughput limit in units for the given SQL database during the time period specified as the Polling Frequency.

Unit: Count

Database throughput units (DTU) used

This metric provides the average database throughput units used for the given SQL database during the time period specified as the polling frequency.

Unit: Count

Sessions percentage

This metric provides the average percentage of available sessions used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

Database size percentage

This metric provides the average percentage of storage used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

Total database size

This metric provides the average for the total database size for the given SQL database during the time period specified as the polling frequency.

Unit: Bytes

Workers percentage

This metric provides the average percentage of available workers used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

Average CPU utilization

This metric provides the average percent CPU used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

Average IO utilization

This metric provides the average percentage of data IO used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

Average log utilization

This metric provides the average percentage of log IO used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

In-Memory OLTP storage percent

This monitor provides the average In-Memory OLTP (Online Transaction Processing) storage percent for the given SQL database during the time period specified as the polling frequency.

Unit: Percent

Database throughput unit (DTU) percentage

This metric provides the average percentage of database throughput units used for the given SQL database during the time period specified as the polling frequency.

Unit: Percent