Documentation forServer & Application Monitor

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

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