Deprecation Notice
This template and all associated files have been deprecated. Please use Microsoft Azure SQL Server Database Elastic Pool - Application Monitor Templates - Server & Application Monitor
This template contains performance & statistics counters for monitoring SQL Server Database Elastic Pool.
Prerequisites:
- PowerShell module (Azure, AzureRM) must be installed prior to running this template
- To connect with Azure account following parameter are required: subcriptionID, ApplicationID, TenantID, Secret Key.
Note: Any Azure App (with its name & ID) having minimum role as 'Read Only'.
- SQL Server Database Elastic Pool name for which metrics must be calculated.
- PowerShell version 5.0 or later.
Credentials:
Login credential to access Azure Portal. This has to be passed as script arguments per prerequisites 2 above. e.g. <subscriptionID>, <TenantID>, <ApplicationID>, value=<Secret Key>, <SQL Server Database Elastic Pool Name>
Optional Parameters which can be passed to script argument:
- value=<Time Interval> - for which data must be fetched (in mins). Default is 10 mins.
- No. of retries as the second last argument (Default is 3)
- WaitTime as the last argument (Default is 0.5 seconds)
Notes:
- To install Azure module, execute below powershell commands;
Install-Module -Name Azure
Install-Module -Name AzureRM
- Windows Administrator on the machine where template would be running against. Script should run with administration privilege
- The ApplicationID with which you are making a connection to Azure portal (as mentioned in Credential/Prerequisites) must be registered in Azure Active Directory as contributor role for the monitored application.
Reference link: https://support.solarwinds.com/Success_Center/Server_Application_Monitor_(SAM)/Knowledgebase_Articles/Add_an_Azure_Active_Directory_app_for_cloud_monitoring_in_the_Orion_Platform
- This template was tested with AzureRM Module 6.9.0
Portions of this document were originally created by and are excerpted from the following sources:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics
MONITORED COMPONENTS
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