This legacy SAM application monitor template contains performance and statistics counters for monitoring SQL Data Warehouse.
Note: This deprecated template is not included in fresh installations of SAM 2020.2 and later. Use the Microsoft Azure Synapse Analytics API poller template instead. If you're new to API Poller templates, watch API Pollers: When SNMP Won't Cut It.
Prerequisites:
- Install a PowerShell module (Azure, AzureRM) before using this template
- To connect with an Azure account, you'll need:
-A SubscriptionID, ApplicationID, TenantID, and Secret Key.
-Any Azure App (with its name and ID) with minimum role of Read Only. - The name of the SQL Data Warehouse for which metrics are calculated.
- PowerShell version 5.0 or later.
Credentials:
- Login credentials for the Azure Portal. passed as script arguments per prerequisites (<SubscriptionID>, <TenantID>, <ApplicationID>, value=<Secret Key>, <SQL Data Warehouse Name>).
- Optional parameters can be passed to the script argument:
- value=<Time Interval> - during which data must be fetched, in minutes. The default is 10 minutes.
- Number of retries as the second last argument; the default is 3.
- WaitTime as the last argument; the default is 0.5 seconds
Portions of this document were originally created by and are excerpted from the following sources: https://docs.microsoft.com/en-gb/azure/sql-data-warehouse/create-data-warehouse-portalhttps://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics
Notes:
- Run scripts with Administrator privilege on target system.
- The ApplicationID with which you are connecting to the Azure portal must be registered in Azure Active Directory as contributor role for the monitored application. See Add an Azure Active Directory app for cloud monitoring in the Orion Platform.
- Portions of this document were originally created by and are excerpted from the following sources:
- Create and query an Azure SQL data warehouse in the Azure portal
- Supported metrics with Azure Monitor. (© 2019 Microsoft Corp., available at https://docs.microsoft.com, obtained on May 8, 2019)
- This template was tested with AzureRM Module 6.9.0.
MONITORED COMPONENTS
Data warehouse units (DWU) utilization
This metric provides 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
This metric provides 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
This metric provides the maximum database throughput units per minute used for the given SQL database during the time period specified as the polling frequency.
Unit: Count
