Azure SQL Database Hyperscale monitoring
- How-to guide
- 2-min read
- Published Apr 13, 2021
Dynatrace ingests metrics from Azure Metrics API for Azure SQL Database Hyperscale. You can view metrics for each service instance, split metrics into multiple dimensions, and create custom charts that you can pin to your dashboards.
Prerequisites
- Dynatrace version 1.215+
- Environment ActiveGate version 1.205+
This service monitors the hyperscale type of SQL Databases. You can find the already monitored resources on the Azure overview page in the Cloud services section or use a dashboard preset. To monitor the SQL Databases user kind, check Azure SQL Servers and the Databases components sections on the Azure overview page.
Enable monitoring
To learn how to enable service monitoring, see Enable service monitoring.
View service metrics
You can view the service metrics in your Dynatrace environment either on the custom device overview page or on your Dashboards page.
View metrics on the custom device overview page
To access the custom device overview page
- Go to Technologies & Processes Classic.
- Filter by service name and select the relevant custom device group.
- Once you select the custom device group, you're on the custom device group overview page.
- The custom device group overview page lists all instances (custom devices) belonging to the group. Select an instance to view the custom device overview page.
View metrics on your dashboard
Once you add a service to monitoring, a preset dashboard for the respective service containing all recommended metrics is automatically created on your Dashboards page. You can look for specific dashboards by filtering by Preset and then by Name.
For existing monitored services, you might need to resave your credentials for the preset dashboard to appear on the Dashboards page. To resave your credentials, go to Settings > Cloud and virtualization > Azure, select the desired Azure instance, then select Save.
You can't make changes on a preset dashboard directly, but you can clone and edit it. To clone a dashboard, open the browse menu (…) and select Clone.
To remove a dashboard from the dashboards list, you can hide it. To hide a dashboard, open the browse menu (…) and select Hide.
Hiding a dashboard doesn't affect other users.
Available metrics
| Name | Description | Unit | Recommended |
|---|---|---|---|
| allocated_data_storage | Data space allocated | Byte |  |
| base_blob_size_bytes | Base blob storage size | Byte | |
| blocked_by_firewall | Blocked by firewall | Count | |
| connection_failed | Failed connections | Count | |
| connection_successful | Successful connections | Count | |
| cpu_limit | CPU limit | Count | |
| cpu_percent | CPU percentage | Percent | |
| cpu_used | CPU used | Count | |
| deadlock | Deadlocks | Count | |
| log_backup_size_bytes | Log backup storage size | Byte | |
| log_write_percent | Log IO percentage | Percent | |
| physical_data_read_percent | Data IO percentage | Percent | |
| sessions_percent | Sessions percentage | Percent | |
| snapshot_backup_size_bytes | Snapshot backup storage size | Byte | |
| sqlserver_process_core_percent | SQL server process core percent | Percent | |
| sqlserver_process_memory_percent | SQL server process memory percent | Percent | |
| tempdb_data_size | Tempdb data file size kb | Count | |
| tempdb_log_size | Tempdb log file size kb | Count | |
| tempdb_log_used_percent | Tempdb percent log used | Percent | |
| workers_percent | Workers percentage | Percent | |
| xtp_storage_percent | In-memory OLTP storage percent | Percent |