Microsoft Azure Synapse Analytics API poller template

Use this template to monitor Microsoft Azure Synapse Analytics (formerly SQL Data Warehouse) performance and statistics counters, including utilization.

Prerequisites

• Values are provided for the following parameters:
  
  • ${SUBSCRIPTION_ID}
  • ${USERGROUP_ID}
  • ${SERVER_ID}
  • ${DATAWAREHOUSE_ID}
• OAuth 2.0 Azure credentials are configured. See API poller authorization and authentication.

Notes

• Default thresholds are not set for this template.
• Here is an API 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