Skip to content

Azure SQL Server

Availability BadgeResource Discovery Support Badge

You can scrape an Azure SQL Server via the SqlServer resource type.

The following fields need to be provided:

  • serverName - The name of the SQL Server instance.

Supported metrics:

  • dtu_consumption_percent - Percentage of consumed CPU across all elastic pools.
  • Requires dimension.name to be set to ElasticPoolResourceId
  • storage_used - Amount of storage data across all elastic pools in bytes.
  • Requires dimension.name to be set to ElasticPoolResourceId
  • dtu_used - Amount of consumed DTU across all databases.
  • Requires dimension.name to be set to DatabaseResourceId

The official Azure Monitor documentation lists more metrics but these are not surfaced externally. However, you can still give them a try but we don't support them for now.

Example

Here is an example configuration:

name: azure_sql_server_dtu_consumption_percent
description: "The DTU consumption percentage used by an Azure SQL Server."
resourceType: SqlServer
azureMetricConfiguration:
  metricName: dtu_used
  dimension:
    name: DatabaseResourceId
  aggregation:
    type: Average
resources:
- serverName: promitor
Back to top