Azure SQL Server

Microsoft Azure Database services provide fully managed relational, NoSQL, and in-memory databases with automated infrastructure management. Azure SQL Server enables you to host enterprise SQL server apps in the cloud.

In Cisco Cloud Observability, Azure SQL Server is categorized as a database instance, or a collection of databases. A database instance entity for Azure SQL Server represents the SQL Server and displays the aggregated metrics of all Azure SQL Databases attached to that Azure SQL Server.

You must configure cloud connections to monitor this entity. See Configure Azure Cloud Connection. For detailed visibility, such as query profiling and streamlined troubleshooting, install Database Monitoring.

Cisco Cloud Observability displays Azure entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.

This document contains references to third-party documentation. Splunk AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.

Detail View

To display the detail view for an Azure SQL Server entity:

Navigate to the Observe page.
Under Database & Storage, click SQL Database Instances.
The list view now displays.
Click the Azure button to display only Azure database entities.
From the list, click a database Name to display the detail view.
The detail view displays metrics, key performance indicators, and properties (attributes) related to the database you selected.

Metrics and Key Performance Indicators

Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for Azure SQL Server. See Supported metrics for Microsoft.Sql/servers/databases.

Display Name	Source Metric Name	Description
DTU Limit (Count)	`dtu_limit`	DTU Limit. Applies to DTU-based databases.
DTU Percentage	`dtu_consumption_percent`	DTU Percentage. Applies to DTU-based elastic pools.
Data IO (%)	`physical_data_read_percent`	The data IO percentage. Aggregated from SQL databases of the server.
Workers Percentage	`workers_percent`	Workers percentage. Not applicable to data warehouses.
In-Memory OLTP Storage Percent	`xtp_storage_percent`	In-Memory OLTP storage percent. Not applicable to data warehouses.
Sessions Percentage	`sessions_percent`	Sessions percentage. Not applicable to data warehouses.
Data Space Allocated (Bytes)	`allocated_data_storage`	Allocated data storage. Not applicable to data warehouses.
CPU Utilization (%)	`cpu_percent`	The CPU percentage. Aggregated from the SQL databases of the server.
Failed Connections (Count)	`connection_failed`	The number of failed connections. Aggregated from the SQL databases of the server.
Data Space Used (Bytes)	`storage`	Data space used. Not applicable to data warehouses.
Deadlocks (Count)	`deadlock`	Deadlocks. Not applicable to data warehouses.
CPU Limit (Cores)	`cpu_limit`	The CPU limit. Applies to vCore-based databases.
DWU Limit (Count)	`dwu_limit`	The DWU limit. Only applies to data warehouses.
DWU Utilization (%)	`dwu_consumption_percent`	The percentage of DWU used. Only applies to data warehouses.
Queries Queued (Count)	`queued_queries`	The count of queued queries across all workload groups. Only applies to data warehouses.
Queries Active (Count)	`active_queries`	The count of active queries across all workload groups. Only applies to data warehouses.
Memory Used Utilization (%)	`memory_usage_percent`	The percentage of memory currently used.
Cache Utilization (%)	`cache_used_percent`	The percentage of used cache. Only applies to data warehouses.

Properties (Attributes)

Cisco Cloud Observability displays the following properties for Azure SQL Server.

Display Name	Source Property Name	Description
Resource Group	`resourceGroup`	The resource group of the database.
Cloud Service	`platform`	The Azure service that the resource belongs to.
ID	`id`	The resource ID of the database.
SQL Server FQDN	`fullyQualifiedDomainName`	The complete domain name for the SQL server.
State	`state`	The current state of the database. Possible values include ONLINE, OFFLINE, or SUSPECT.
Type	`type`	The database type.
Name	`name`	The name of the SQL server.
Version	`version`	The version of the SQL server.

Retention and Purge Time-To-Live (TTL)

For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).

Microsoft Azure, the Microsoft Azure logo, Azure, and any other Microsoft Azure Marks used in these materials are trademarks of Microsoft Corporation or its affiliates in the United States and/or other countries.