Microsoft Azure SQL Database [Deprecated]

Deprecation Notice

This template and all associated files have been deprecated.  Please use Microsoft Azure SQL Database - Application Monitor Templates - Server & Application Monitor


This template contains performance & statistics counters for monitoring Azure Sql Server Database.


Prerequisites:

  1. PowerShell module (Azure, AzureRM) must be installed prior to running this template
  2. 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'.

  1. SQL Server Database Name for which metrics must be calculated.
  2. 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 Name> Optional Parameters which can be passed to script argument:

  1. value=<Time Interval> - for which data must be fetched (in mins). Default is 10 mins.
  2. No. of retries as the second last argument (Default is 3)
  3. WaitTime as the last argument (Default is 0.5 seconds)

Notes:

  1. To install Azure module, execute below powershell commands;

Install-Module -Name AzureInstall-Module -Name AzureRM

  1. Windows Administrator on the machine where template would be running against. Script should run with administration privilege

  1. 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

  1. 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://azure.microsoft.com/en-in/blog/windows-azure-sql-database-management-with-powershell/

https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics

MONITORED COMPONENTS

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