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¶
Here is an example configuration:
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