Azure SQL Managed Instances

Azure SQL Managed Instance provides an intelligent cloud database service combining the broadest SQL Server engine compatibility (back to SQL Server 2008) with the benefits of a fully managed, up-to-date platform as a service. With your successful assessment on Azure Migrate or Azure Data Studio, confidently modernize your custom and vendor-provided apps to Azure. With Observe’s SQL Managed Instance integration, you can gain valuable insights into how your SQL Managed Instances and their databases perform.

Installed Datasets for Azure SQL Managed Instances

  • Azure SQL Managed Instance

  • Azure SQL Managed Instance Logs

  • Azure SQL Managed Instance Metrics

  • Azure SQL Managed Instance Database

  • Azure SQL Managed Instance Database Error Logs

  • Azure SQL Managed Instance Database Wait Statistics

  • Azure SQL Managed Instance Database Query Store Runtime Metrics

Azure SQL Managed Instances Monitor Templates

  • Azure SQL Managed Instance CPU Threshold - Alert when the CPU percent of an Azure SQL Managed Instance exceeds a threshold for a given period.

  • Azure SQL Managed Instance Storage Space Used greater than 80% - Alert when storage space allocated Azure SQL Managed Instance exceeds 80% for a given period.

Viewing Azure SQL Managed Instance in Observe

The Azure SQL Managed Instance Monitoring dashboard, included in the Azure SQL Managed Instance resource dataset, helps you answer the following questions:

  • What resources are my databases using, such as CPU, storage, and throughput?

  • Which Databases are associated with my SQL Managed Instance?

Monitoring dashboard for SQL Managed Instance

Figure 1 - The Monitoring dashboard for SQL Managed Instance

Once you locate an Azure SQL Managed Instance of interest, you can click on the name of the database, and click Open from the right menu. This takes you to the Azure SQL Managed Database Instance Monitoring dashboard. This dashboard includes more detailed information, including:

  • Database Connections

  • How long is my average query duration?

  • How long is my average query wait time?

Instance Monitoring dashboard for Azure SQL Managed Instance Database

Figure 2- The instance Monitoring dashboard for AzureSQL Managed Instance Database

Setup - Installing SQL Managed Instance

By default, the Observe Azure App enables the SQL Managed Instance service when installed.

If you don’t see the listed datasets, perform the following steps:

  • Select Apps icon from the left menu.

  • Click Manage on the Azure app card.

  • Click the Configuration tab.

  • Be sure you enabled the Azure SQL Managed Instances Service.

Enabling the SQL Managed Instances Service

Figure 3 - Enabling Azure SQL Managed Instances Service

SQL Managed Instance Metrics

To learn more about Azure SQL Managed Instance Metrics, see Monitor Azure SQL Managed Instance with Azure Monitor.