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.
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://docs.promitor.io/latest/how-it-works#using-resource-discovery) - name: sql-elastic-pools