Microsoft Azure SQL Server Database
This SAM application monitor template contains performance and statistics counters for monitoring a SQL Server Database.
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 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 Server Database 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 Server Database 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
- 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 SolarWinds Platform
- Portions of this document were originally created by and are excerpted from the following sources:
- Windows Azure SQL Database Management with PowerShell
- 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.
Component monitors
Blocked Connections
This metric provides the average number of firewall blocked connections established for the given SQL database during the time period specified as the Polling Frequency.
Unit: Count
Failed Connections
This monitor provides the average number of failed connections established for the given SQL database during the time period specified as the Polling Frequency.
Unit: Count
Successful Connections
This metric provides the average number of successful connections established for the given SQL database during the time period specified as the Polling Frequency.
Unit: Count
Deadlocks
This metric provides the average number of deadlocks established for the given SQL database during the time period specified as the Polling Frequency.
Unit: Count
Database throughput units (DTU) Limit
This metric provides the average database throughput limit in units for the given SQL database during the time period specified as the Polling Frequency.
Unit: Count
Database throughput units (DTU) used
This metric provides the average database throughput units used for the given SQL database during the time period specified as the polling frequency.
Unit: Count
Sessions percentage
This metric provides the average percentage of available sessions used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Database size percentage
This metric provides the average percentage of storage used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Total database size
This metric provides the average for the total database size for the given SQL database during the time period specified as the polling frequency.
Unit: Bytes
Workers percentage
This metric provides the average percentage of available workers used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Average CPU utilization
This metric provides the average percent CPU used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Average IO utilization
This metric provides the average percentage of data IO used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Average log utilization
This metric provides the average percentage of log IO used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
In-Memory OLTP storage percent
This monitor provides the average In-Memory OLTP (Online Transaction Processing) storage percent for the given SQL database during the time period specified as the polling frequency.
Unit: Percent
Database throughput unit (DTU) percentage
This metric provides the average percentage of database throughput units used for the given SQL database during the time period specified as the polling frequency.
Unit: Percent