Azure SQL Managed Instances

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

  • SQL Managed Instance

  • SQL Managed Instance Logs

  • SQL Managed Instance Metrics

  • SQL Managed Instance Database

  • SQL Managed Instance Database Error Logs

  • SQL Managed Instance Database Wait Statistics

  • SQL Managed Instance Database Query Store Runtime Metrics

SQL Managed Instances Monitor Templates

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

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

Viewing Azure SQL Managed Instance in Observe

The SQL Managed Instance Monitoring dashboard, included in the 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 a SQL Managed Instance of interest, you can click on the name of the database, you can click on the name of the database, and click Open from the right menu. This takes you to the 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 SQL Managed Instance Database

Figure 2- The instance Monitoring dashboard for SQL 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 SQL Managed Instances Service.

Enabling the SQL Managed Instances Service

Figure 3 - Enabling SQL Managed Instances Service

SQL Managed Instance Metrics

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