Microsoft Azure Synapse Analytics API poller template
Use this SAM API poller template to monitor Microsoft Azure Synapse Analytics (formerly SQL Data Warehouse) performance and statistics counters, including utilization.
Prerequisites
- Provide values for the following parameters:
- ${SUBSCRIPTION_ID}
- ${USERGROUP_ID}
- ${SERVER_ID}
- ${DATAWAREHOUSE_ID}
- Configure OAuth 2.0 Azure credentials.
See also API poller authorization and Find Microsoft Azure credentials.
Notes
- Default thresholds are not set for this template.
- Here is a request example:
https://management.azure.com/subscriptions/${SUBSCRIPTION_ID}/resourceGroups/${USERGROUP_ID}/providers/Microsoft.Sql/servers/${SERVER_ID}/databases/${DATAWAREHOUSE_ID}/providers/microsoft.insights/metrics?interval=PT1H&metricnames=dwu_consumption_percent,dwu_limit,dwu_used&aggregation=Maximum&api-version=2019-07-01
Available metrics
Data warehouse units (DWU) utilization
The maximum percentage of database warehouse units used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Data warehouse units (DWU) limit
The maximum database warehouse limit in units for the given SQL database during the time period specified as the polling frequency.
Unit: Count
Data warehouse units (DWU) used
The maximum database throughput units per minute used for the given SQL database during the time period specified as the polling frequency.
Unit: Count