Documentation forServer & Application Monitor

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

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