Azure SQL Managed Instance
A managed SQL Server instance service offered by Microsoft Azure that provides near-complete SQL Server compatibility, supports migration from on-premises to the cloud, and combines the convenience of a managed service with high compatibility.
Core Facts
Timeline (last 90 days)
The Azure SQL family offers three main targets: SQL Server on Azure VM, Azure SQL Database (including Hyperscale) and Azure SQL Managed Instance.
Managed Instance Link (MI Link) is implemented based on the distributed availability group mechanism, establishing a continuous data synchronization link between the source SQL Server and the target Azure SQL Managed Instance.
Log Replay Service is mainly aimed at scenarios where Azure SQL Managed Instance restores backup files from Azure Blob Storage, achieving near-real-time data synchronization by continuously restoring log backups.
The General Purpose service tier uses remote storage (Azure Premium SSD or Ultra Disk) with compute and storage separated; Business Critical uses local SSD storage with built-in Always On availability group replicas.
Choosing the Always up-to-date update policy provides the fastest access to new engine features on the Azure side, but the database format may diverge, thereby losing the exit path of backup/restore and physical replication back to SQL Server (data copy mechanisms such as export/import and transactional replication remain available).
All Facts (6)
Azure SQL Database, SQL Managed Instance, and on-premises SQL Server 2022+ share the same core query engine (SQL OS + Query Processor).
65%UnverifiedThe Azure SQL family offers three main targets: SQL Server on Azure VM, Azure SQL Database (including Hyperscale) and Azure SQL Managed Instance.
50%UnverifiedManaged Instance Link (MI Link) is implemented based on the distributed availability group mechanism, establishing a continuous data synchronization link between the source SQL Server and the target Azure SQL Managed Instance.
50%UnverifiedLog Replay Service is mainly aimed at scenarios where Azure SQL Managed Instance restores backup files from Azure Blob Storage, achieving near-real-time data synchronization by continuously restoring log backups.
50%UnverifiedThe General Purpose service tier uses remote storage (Azure Premium SSD or Ultra Disk) with compute and storage separated; Business Critical uses local SSD storage with built-in Always On availability group replicas.
50%UnverifiedChoosing the Always up-to-date update policy provides the fastest access to new engine features on the Azure side, but the database format may diverge, thereby losing the exit path of backup/restore and physical replication back to SQL Server (data copy mechanisms such as export/import and transactional replication remain available).
50%