Learn about the Microsoft Azure SQL Database Integration.

Microsoft Azure Integration

The Microsoft Azure integration enables monitoring Azure with Wavefront and offers pre-defined dashboards and alert conditions.

Dashboards

Wavefront provides Microsoft Azure dashboards for the following services:

  • Azure: Application Gateway
  • Azure: App Service
  • Azure: Container Instances
  • Azure: Cosmos DB
  • Azure: Event Hubs
  • Azure: Files
  • Azure: Functions
  • Azure: HDInsight
  • Azure: Kubernetes Service
  • Azure: Load Balancer
  • Azure: Cache for Redis
  • Azure: Storage Accounts
  • Azure: SQL Database
  • Azure: SQL Data Warehouse
  • Azure: Summary
  • Azure: Virtual Machine
  • Azure: Virtual Machine Scale Set

Here’s a preview of the Virtual Machine dashboard: images/azure-overview.png

Metrics Configuration

Wavefront ingests Microsoft Azure metrics using the Azure Monitor APIs. For details on the metrics that the API supports, see the documentation.

Metrics originating from Microsoft Azure are prefixed with azure. within Wavefront. After you set up the integration, you can browse the available metrics in the Metrics browser. Simply click Browse > Metrics from the taskbar and search for azure..

The metric names consist of the actual metric name and a suffix for the aggregation type. The default metric name without a suffix corresponds to the total aggregation type.
For example, the metric names for metric azure.compute.vm.percentage.cpu are:

azure.compute.vm.percentage.cpu.average
azure.compute.vm.percentage.cpu.maximum
azure.compute.vm.percentage.cpu.minimum
azure.compute.vm.percentage.cpu.count
azure.compute.vm.percentage.cpu (corresponds to azure.compute.vm.percentage.cpu.total)

Metrics Information

You can see the information about the metrics on the Azure metrics doc site. Click a link below to see the detailed metrics information per service:

Microsoft Azure Integrations

Add a Microsoft Azure Cloud Integration

Adding a Microsoft Azure cloud integration requires establishing a trust relationship between Azure and VMware Aria Operations for Applications (formerly known as Tanzu Observability by Wavefront). The overall process involves the following:

  • Getting a Directory ID
  • Creating an Azure Active Directory application that represents Operations for Applications inside Azure and getting the Application ID.
  • Creating a secret key and getting the Application secret.

To register a Microsoft Azure Cloud Integration:

  1. In the Name text box, enter a meaningful name.
  2. In the Directory ID text box, enter your Microsoft Azure Directory ID.
  3. In the Application ID text box, enter the Azure Active Directory Application (client) ID.
  4. In the Application Secret text box, enter the secret key that you created. Note: The Azure application secret that you enter is securely stored and never exposed except for read only access to the Azure APIs.
  5. (Optional) Enter the category names to fetch.
  6. (Optional) In the Metric Allow List text box, you can add metrics to an allow list by entering a regular expression. For example, ^azure.(compute|dbforpostgresql).*$.
  7. (Optional) Enter the resource group names to fetch.
  8. Select whether you want to fetch logs. If you decide that you want to fetch activity logs, you can also specify the log categories to fetch, e.g. Administrative, Service health, Alert, and so on.
  9. Click Register.

Alerts

  • Azure Instance CPU Usage Too High:Alert reports when the Azure Instance CPU utilization constantly exceeds the defined limit.
  • Azure Disk IOPS Consumed Percentage Too High:Alert reports when the Azure Disk IOPS consumed percentage constantly exceeds the defined limit.
Metric Name Description
azure.sql.servers.databases.blocked_by_firewall.* Number of connections blocked by Firewall.
Statistics: count
azure.sql.servers.databases.connection_failed.* Failed Connections.
Statistics: count
azure.sql.servers.databases.connection_successful.* Successful Connections.
Statistics: count
azure.sql.servers.databases.cpu_percent.* CPU percentage.
Statistics: count
azure.sql.servers.databases.deadlock.* Number of deadlocks.
Statistics: count
azure.sql.servers.databases.log_write_percent.* Log IO percentage.
Statistics: count
azure.sql.servers.databases.physical_data_read_percent.* Data IO percentage.
Statistics: count
azure.sql.servers.databases.sessions_percent.* Sessions percentage.
Statistics: count
azure.sql.servers.databases.workers_percent.* Workers percentage.
Statistics: count
azure.sql.servers.databases.xtp_storage_percent.* In-Memory OLTP storage percent.
Statistics: count