Documentation forServer & Application Monitor

Microsoft Azure SQL Data Warehouse

This template contains performance and statistics counters for monitoring SQL Data Warehouse.

For an overview of configuring Azure application monitor templates, watch SolarWinds Lab #82 (Part 2).

Tip: Consider using one of the new SAM API Poller templates designed for Azure instead of legacy application monitor templates.

Prerequisites

  • PowerShell module (Azure, AzureRM) is installed before using this template.

    To install the Azure module, execute these PowerShell commands:

    • Install-Module -Name Azure
    • Install-Module -Name AzureRM
  • To connect with the Azure account, you'll need the SubscriptionID, ApplicationID, TenantID, and Secret Key.
    Any Azure App (with its name and ID) having minimum role as Read Only
  • SQL Data Warehouse name for which metrics are being calculated.
  • PowerShell 5.0 or later.

Credentials

  • Login credential to access 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 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

Notes

Component monitors

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