Azure SQL Database Hyperscale monitoring

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+

Enable monitoring

To enable monitoring for this service, you first need to set up integration with Azure Monitor.

Add the service to monitoring

In order to view the service metrics, you must add the service to monitoring in your Dynatrace environment.

Monitor resources based on tags

You can choose to monitor resources based on existing Azure tags, as Dynatrace automatically imports them from service instances.

To monitor resources based on tags

  1. Go to Settings > Cloud and virtualization > Azure and select the Azure instance.
  2. For Resource monitoring method, select Monitor resources based on tags.
  3. Enter the Key and Value.
  4. Select Save.

Note: To import the Azure tags automatically into Dynatrace, enable Capture Azure tags automatically.

Configure service metrics

Once you add a service, Dynatrace starts automatically collecting a suite of metrics for this particular service. These are recommended metrics.

Recommended metrics:

  • Are enabled by default
  • Can't be disabled
  • Can have recommended dimensions (enabled by default, can't be disabled)
  • Can have optional dimensions (disabled by default, can be enabled).

Apart from the recommended metrics, most services have the possibility of enabling optional metrics.

Optional metrics:

  • Can be added and configured manually

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

  1. Go to Technologies on the Dynatrace navigation menu.
  2. Filter by service name and select the relevant custom device group.
  3. Once you select the custom device group, you're on the custom device group overview page.
  4. 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.

Note: 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.
Note: Hiding a dashboard doesn't affect other users.
clone-hide-azure

hyperscale

Available metrics

Name Description Unit Recommended
allocated_data_storage Data space allocated Byte ✔️
base_blob_size_bytes Base blob storage size Byte
base_blob_size_bytes 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