Azure SQL Managed Instance

On the Azure SQL Managed Instance overview page you get insights into various aspects of database performance, including CPU usage, virtual core count, storage space, IO bytes sent/received, and much more.

Enable monitoring

To enable monitoring for Azure SQL Managed Instance, you first need to set up integration with Azure Monitor.
Optionally, for OneAgent integration, see how database activity is monitored.

Add the service to monitoring

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

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

Once you add the service to monitoring, you can view the service metrics in your Dynatrace environment either on your dashboard page or on the custom device overview page.

Import preset dashboards

Dynatrace provides preset Azure dashboards that you can import from GitHub to your environment's dashboard page. Once you download a preset dashboard locally, there are two ways to import it.

sql-dash

Available metrics

Name Description Unit Recommended
avg_cpu_percent Average CPU percentage Percent ✔️
io_bytes_read IO bytes read Bytes ✔️
io_bytes_written IO bytes written Bytes ✔️
io_requests IO requests count Count ✔️
reserved_storage_mb Storage space reserved Count ✔️
storage_space_used_mb Storage space used Count ✔️
virtual_core_count Virtual core count Count ✔️