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.

Prerequisites

Dynatrace version 1.196+
Environment ActiveGate version 1.195+

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.

To add a service to monitoring

Go to Settings > Cloud and virtualization and select Azure.
On the Azure overview page, scroll down and select the desired instance. Select the Edit button.
Scroll down, select Manage services and Add service. Choose the service name from the drop-down and select Add service.
Select Save changes.

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

To add and configure metrics

Go to Settings > Cloud and virtualization and select Azure.
On the AWS overview page, scroll down and select the desired AWS instance. Select the Edit button.
Scroll down to the Supporting services section and select Manage services.
To add a metric, select the service for which you want to add metrics.
Select Add metric.
From the menu, select the metric you want.
Select Add metric to add the metric to monitoring.
To configure a metric, select the Edit button associated with it.
Select Apply to save your configuration.

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.

To access the custom device overview page

Go to Technologies on the main menu of your Dynatrace environment.
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.

Example of 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.

Example of custom device overview page

Import preset dashboards

Dynatrace provides preset Azure dashboards that you can import from GitHub to your environment's Dashboards page.
Note: To save a preset dashboard locally, create a new JSON file on your local machine and copy-paste the content of the JSON file from GitHub into the new file.
Once you save a preset dashboard locally, there are two ways to import it.

Import via Dynatrace web UI

Select Dashboards from the navigation menu and choose your dashboard (or create a new one by selecting Create Dashboard).
On your dashboard, select Edit > Settings >Advanced settings > Dashboard JSON.
Copy the whole ID row from the Dashboard JSON file as shown in the image below.
Select Upload to choose and upload the dashboard JSON file that you want to use in your Dynatrace environment.
In the editor of the imported JSON file, paste the ID row right after the opening bracket, on the second row of the Dashboard JSON, as shown below.
Search for the owner parameter and replace the empty value with the email address that is used for your Dynatrace subscription. Or, if the owner parameter is missing, add it as shown below.

    "id": "<your_dashboard_id>",
    "dashboardMetadata": {
        "name": "<your_dashboard_name>",
        "shared": false,
        "owner": "<your_email_address>",
        "sharingDetails": {
            "linkShared": true,
            "published": false

Note: The name you selected for the new dashboard will be overwritten with the name of the preset dashboard. To modify the name, edit the JSON file by replacing the value of the name parameter with your desired dashboard name.
8. Select Save changes.

Import via Dynatrace API

Create an API token.
When creating the token, enable the Write configuration permission.
To import the dashboard, run the command below, replacing {DYNATRACE_HOST}, {DYNATRACE_TENANT}, {TOKEN}, and {PATH_TO_DASHBOARD} with your own values.

curl --location --request POST 'http://{DYNATRACE_HOST}/e/{DYNATRACE_TENANT}/api/config/v1/dashboards' \
--header 'Authorization: Api-Token {TOKEN}' \
--header 'Content-Type: application/json' \
--data-binary '{PATH_TO_DASHBOARD}'

For more information, see Dashboards API - POST a dashboard

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	✔️