Azure SQL Database

Microsoft Azure Database services provide fully managed relational, NoSQL, and in-memory databases with automated infrastructure management. Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles database management functions such as upgrading, patching, backups, and monitoring without user involvement.

In Cisco Cloud Observability, Azure SQL Database is categorized as a database, or a collection of database tables. A database entity for the Azure SQL Database represents the SQL Database.

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 Database entity:

Navigate to the Observe page.
Under Database & Storage, click SQL Database Instances.
In the Relationships map in the left-hand navigation, click Databases.
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 Database. See Supported metrics for Microsoft.Sql/servers/databases.

Display Name	Source Metric	Description
DTU Limit (Count)	`dtu_limit`	DTU Limit. Applies to DTU-based databases. The availability of this metric may vary depending on the configuration of your Azure resource.
DTU Percentage	`dtu_consumption_percent`	DTU Percentage. Applies to DTU-based databases.
Data IO (%)	`physical_data_read_percent`	The data IO percentage.
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.
Failed Connections (Count)	`connection_failed`	The number of failed connections.
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 Database.

Display Name	Property Name	Description
Resource Group	`resourceGroup`	The resource group of the database.
ID	`resourceId`	The resource ID of the database.
Cloud Service	`platform`	The Azure service that the resource belongs to.
DB Instance ID	`id`	The ID of the DB instance in the SQL server.
Max Size Bytes	`maxSizeBytes`	The allocated storage of the database.
Type	`type`	The database type.
Creation Date	`creationDate`	The creation date of the database.
Name	`name`	The name of the database.
SQL Server Name	`serverName`	The name of the SQL server.
SKU	`skuName`	The SKU name of the database.
SKU Tier	`skuTier`	The SKU tier of the database.
Version	`kind`	The SQL server version.
State	`state`	The current state of the SQL Server. Examples of states include RUNNING and PAUSED.

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.