---
updatedAt: 2026-09-10T18:30:41.000Z
agentTools:
  projectIndex: https://docs.observeinc.com/llms.txt
---

# Azure SQL Managed Instances

[Azure SQL Managed Instance](https://azure.microsoft.com/en-us/products/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 the **SQL Managed Instance** integration, you can gain valuable insights into how your SQL Managed Instances and their databases perform.

# Installed Datasets installed for Azure SQL Managed Instances

The following Datasets are installed 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.

# View Azure SQL Managed Instance in Observe by Snowflake

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?

<Image src="https://files.readme.io/99399c7cb52f1f35d78ea7b0ecd069856fbcea3c2870c3dca423958226c2f3b0-Azure_SQL_Managed_Instance.png" align="center" border={true} />

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?

<Image src="https://files.readme.io/5f3e55805267812c1bb31aa6d73d5035a010aca5ac0728f9c17228687bf02ade-Azure_SQL_Managed_Instance_Database.png" align="center" border={true} />

# Setup - Install SQL Managed Instance

By default, the **Azure** app enables the **SQL Managed Instance** service when installed.

If you don't see the listed Datasets, perform the following steps:

* Select **Data & integrations > Applications** icon from the left menu.
* Click **Manage** on the **Microsoft Azure** app card.
* Click the **Configuration** tab.
* Be sure you enabled the **Azure SQL Managed Instances Service**.

<Image src="https://files.readme.io/7914ec9b2c73cfbd938dc5160ad082dc3a446986741cac99968ead43ece97f1e-Azure_SQL_Managed_Instances.png" align="center" width="600em" border={true} />

# Azure SQL Managed Instance metrics

To learn more about Azure SQL Managed Instance metrics, see [Monitor Azure SQL Managed Instance with Azure Monitor](https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor?view=azuresql) in the Microsoft documentation.