Managed Instance closely aligns with on-premises SQL Server, offering near-complete feature parity and enabling easy migration of SQL Server applications to the cloud without code changes. It’s designed for predictable performance and environmental control, crucial for mission-critical workloads. The native virtual network ensures isolated and secure database environments.
Performance in Managed Instance is tailored to the selected service tier, addressing various workload requirements. The General Purpose tier suits standard business applications with typical I/O demands. Meanwhile, the Business Critical tier is geared towards high-performance applications, featuring faster compute, higher I/O throughput, and in-memory technologies like In-Memory OLTP for demanding workloads. Recent updates have introduced doubled max log rate for the Business Critical tier and support for new features like fast provisioning and improved network security.
Pricing for Azure SQL DB and Managed Instance is based on factors including service tier, compute resources (vCore), and storage.
- Azure SQL DB offers flexibility with options like serverless compute, which can help optimize costs by automatically scaling compute resources and billing only for the resources used.
- Managed Instance pricing is generally based on the chosen tier and allocated resources suitable for predictable workloads. Both services offer pricing models to cater to various business needs and workload requirements.
Azure SQL Managed Instance has two main service tiers: General Purpose and Business Critical. The General Purpose tier uses Azure Premium Storage, suitable for applications with standard performance and I/O latency needs. It provides a cost-effective solution for various workloads. The Business Critical tier employs local SSD storage for higher performance requirements, offering features like in-memory OLTP and additional read-only replicas. Storage limits and I/O throughput scale with the provisioned database compute resources, allowing for effective performance and cost balance in both tiers.