Microsoft Azure SQL Database Integration

This page provides an overview of what you can do with the Microsoft Azure SQL Database integration. The documentation pages only for a limited number of integrations contain the setup steps and instructions. If you do not see the setup steps here, navigate to the Operations for Applications GUI. The detailed instructions for setting up and configuring all integrations, including the Microsoft Azure SQL Database integration are on the Setup tab of the integration.

1. Log in to your Operations for Applications instance.
2. Click Integrations on the toolbar, search for and click the Microsoft Azure SQL Database tile.
3. Click the Setup tab and you will see the most recent and up-to-date instructions.

Microsoft Azure Integration

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

Dashboards

Tanzu Observability 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:

Metrics Configuration

Tanzu Observability 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 Tanzu Observability. 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:

• 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 Virtual Machine
• Azure Virtual Machine Scale Set

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).*$.

   Note: Metric names consist of the actual metric name and a suffix (starting with a dot (“.”)). The suffix represents an aggregation type. In the regular expression, you must use the actual metric names without the aggregation types, such as: count, average, minimum, maximum, sum, and so on.

   For example, the metric names for the 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)

   Here, the actual metric name is azure.compute.vm.percentage.cpu, while average, maximum, minimum, and count are the aggregation types. When you create the regular expression, you must use only azure.compute.vm.percentage.cpu. For example, ^azure.compute.vm.percentage.cpu$.

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