Microsoft Azure SQL Server Database Elastic Pool
This SAM application monitor template contains metrics for monitoring SQL Server Database Elastic Pool. Some counters may require manual configuration, such as setting up installation-specific instances or correcting thresholds for your environment.
Passwords for legacy Microsoft Azure application monitor templates and related application monitors are stored as plain text in the SolarWinds Platform database. SolarWinds recommends switching to Microsoft Azure API poller templates that leverage OAuth 2.0 authorization.”
Prerequisites
-
PowerShell modules (Az, Az.Accounts, Az.Resources) installed
-
Parameters for connecting to your Azure account
-
Subscription ID
-
Application ID
-
Tenant ID
-
Secret Key
-
-
Any Azure App (with its name and ID) having minimum role as Read Only
-
SQL Server Database Elastic Pool name for which metrics are being calculated
-
PowerShell 5.1 or later
Credentials
- Windows Administrator privileges on the target system
- Login credential to access the Azure Portal, passed as script arguments per prerequisites (<SubscriptionID>, <TenantID>, <ApplicationID>, value=<Secret Key>, <SQL Server Database Name>).
- Optional parameters can be passed to script argument:
- Time interval for which data has to be fetched (in hours).
- Number of retries as the second last argument; the default is 3 retries.
- WaitTime as the last argument; the default is 0.5 seconds.
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 read-only/contributor role for the monitored application. See Add an Azure Active Directory app for cloud monitoring in the SolarWinds Platform.
- Portions of this document were originally created by and are excerpted from the following sources:
Component monitors
CPU percentage
This metric provides the average compute utilization in percentage of the limit of the given SQL database pool during the time period specified as the Polling Frequency.
Unit: Percent
DTU percentage
This monitor provides the average eDTU utilization in percentage of eDTU limit of the given SQL database pool during the time period specified as the Polling Frequency.
Unit: Percent
eDTU (Database Throughput Unit) limit
This metric provides the current average elastic pool DTU setting for the given SQL database pool during the time period specified as the Polling Frequency.
Unit: Count
eDTU (Database Throughput Unit) used
This metric provides the average eDTUs used by the given SQL database pool during the time period specified as the Polling Frequency.
Unit: Count
Log IO percentage
This metric provides the average write resource utilization in percentage of the limit of the given SQL database pool during the time period specified as the Polling Frequency.
Unit: Percent
Data IO percentage
This metric provides the average I/O utilization in percentage based on the limit of the given SQL database pool during the time period specified as the polling frequency.
Unit: Percent
Sessions percentage
This metric provides the average concurrent sessions in percentage based on the limit of the given SQL database pool during the time period specified as the polling frequency.
Unit: Percent
Storage limit
This metric provides the current average elastic pool storage limit setting for the given SQL database pool in megabytes during the time period specified as the polling frequency.
Unit: Bytes
Storage percentage
This metric provides the current average elastic pool storage used percentage for the given SQL database pool during the time period specified as the polling frequency.
Unit: Percent
Storage used
This metric provides the average storage used by the pool in bytes during the time period specified as the polling frequency.
Unit: Bytes
Workers percentage
This metric provides the average concurrent workers (requests) in percentage based on the limit of the given SQL database pool during the time period specified as the polling frequency.
Unit: Percent