Azure SQL Managed Instance monitoring

  • How-to guide
  • 1-min read
  • Published Jul 02, 2020

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.

Prerequisites

  • Dynatrace version 1.196+
  • Environment ActiveGate version 1.195+

Enable monitoring

To learn how to enable service monitoring, see Enable service monitoring.

Optionally, for OneAgent integration, see how database activity is monitored.

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 & Processes Classic.
  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.

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.

Clone hide azure

SQL dash

Available metrics

NameDescriptionUnitRecommended
avg_cpu_percentAverage CPU percentagePercentApplicable
io_bytes_readIO bytes readBytesApplicable
io_bytes_writtenIO bytes writtenBytesApplicable
io_requestsIO requests countCountApplicable
reserved_storage_mbStorage space reservedCountApplicable
storage_space_used_mbStorage space usedCountApplicable
virtual_core_countVirtual core countCountApplicable
Related tags
Infrastructure Observability