Azure SQL Elastic Pool¶
You can scrape an Azure SQL Elastic Pool via the SqlElasticPool
resource type.
When using declared resources, the following fields need to be provided:
serverName
- The name of the SQL Server instance.poolName
- The name of the elastic pool.
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.elastic_pool
- The name of the elastic pool.
Example¶
Here is an example configuration:
- name: promitor_demo_sql_elastic_pool_cpu
description: "CPU percentage used for a Azure SQL Elastic Pool"
resourceType: SqlElasticPool
labels:
app: promitor
azureMetricConfiguration:
metricName: cpu_percent
aggregation:
type: Average
resources: # Optional, required when no resource discovery is configured
- serverName: promitor-sql-server
poolName: promitor-db
resourceDiscoveryGroups: # Optional, requires Promitor Resource Discovery agent (https://promitor.io/concepts/how-it-works#using-resource-discovery)
- name: sql-elastic-pools