Azure SQL Database
You can scrape an Azure SQL Database via the SqlDatabase resource type.
When using declared resources, the following fields need to be provided:
serverName- The name of the SQL Server instance.databaseName- The name of the database.
All supported metrics are documented in the official Azure Monitor documentation.
The following scraper-specific metric labels will be added:
server- The name of the SQL Server instance.database- The name of the database.
Example:
name: azure_sql_database_dtu_consumption_percent
description: "The DTU consumption percentage used by an Azure SQL Database."
resourceType: SqlDatabase
azureMetricConfiguration:
metricName: dtu_consumption_percent
aggregation:
type: Average
resources: # Optional, required when no resource discovery is configured
- serverName: promitor-sql-server
databaseName: promitor-db
resourceDiscoveryGroups: # Optional, requires Promitor Resource Discovery agent (https://promitor.io/concepts/how-it-works#using-resource-discovery)
- name: sql-database-landscape