Skip navigation

Azure SQL Managed Instance

Modernize SQL Server applications with a managed, always-up-to-date SQL instance in the cloud

Easily migrate your SQL Server apps to the cloud

Part of the Azure SQL family, SQL Managed Instance is 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 modernise your customised and vendor-provided apps to Azure.

The broadest SQL Server engine compatibility accelerates modernisation to Azure

Savings of up to 55 percent compared to pay-as-you-go pricing when you reuse your SQL licences with Azure Hybrid Benefit1

Hybrid flexibility with the link feature and Azure Arc-enabled data services brings cloud connectivity and Azure innovation on premises

Always operate on the latest version of SQL

Stop worrying about updates, upgrades, or end of support. SQL Managed Instance is built on the SQL Server engine, so it's always up to date with the latest SQL features and functionality.

See supported features

Optimise price-performance and lower your costs

Meet your mission-critical requirements up to five times faster while paying up to 93 percent less than AWS RDS.2 Learn how SQL Managed Instance outperformed across three different benchmarks, spanning transactional and analytics workloads.

Read the report

Maintain SQL Server compatibility

Accelerate application modernisation with the latest managed SQL Server capabilities in the cloud. Keep using familiar tools and SQL Server features like cross-database queries, linked server, and support for Windows authentication with an entire SQL Server instance within a managed service. Move your customised and vendor-provided apps without worrying about compatibility or performance changes – SQL Managed Instance maintains the highest SQL Server compatibility levels.

Compare features

An example of maintaining SQL server application compatibility

Increase database administrator productivity

Boost productivity and operate more efficiently by letting the fully managed service perform time-consuming and complex tasks on your behalf. Take advantage of built-in high availability, accelerated database recovery, and automated backups to help ensure that your data is available when you need it, and use AI-powered automatic tuning to optimise performance. Get the best of SQL Server with the financial and operational benefits of a platform as a service.

Read the overview

Fully isolate and secure your data

Achieve isolation at both the compute level and the network level. Ensure that your instances and databases don't share virtual machines with other customers. Keep workloads fully contained within a secure native virtual network, and get the benefits of the public cloud while remaining isolated from the public internet.

See connectivity architecture

Advanced data security

  • Remediate potential threats in real time with intelligent threat protection and proactive vulnerability assessment alerts.
  • Get industry-leading, multi-layered protection with built-in security controls including network security, encryption, and access and key management.
  • Take advantage of the most comprehensive compliance coverage of any cloud database service.
  • Protect your data with Always Encrypted technology, where encryption keys are never revealed to the database engine.

Pricing for the always-up-to-date SQL instance in the cloud

Explore pricing options and find the one that fits your workload.

Get started with an Azure free account

Start free. Get $200 credit to use within 30 days. While you have your credit, get free amounts of many of our most popular services, plus free amounts of 40+ other services that are always free.

After your credit, move to pay as you go to keep building with the same free services. Pay only if you use more than your free monthly amounts.

After 12 months, you'll keep getting 40+ always-free services—and still pay only for what you use beyond your free monthly amounts.

Trusted by companies of all sizes

Achieving breakthrough performance and savings

Learn how Komatsu Australia reduced costs by 49 percent and increased performance by up to 30 percent by migrating its data to SQL Managed Instance.

Komatsu

Supporting growth and flexibility

Learn how Descartes benefited from fully managed SQL Managed Instance and successfully met the high transaction demands of its MacroPoint app.

Descartes

Maximising vaccine accessibility through scalability

Learn how Mosaic Life Care used SQL Managed Instance to enable easy access to COVID-19 vaccinations and reduce its IT administrative burden.

Mosaic

Collaborating with agility on Azure

See how Wolters Kluwer reduced its administrative tasks, saved time, and improved its overall platform availability and performance using SQL Managed Instance.

Wolters Kluwer

Improving business-critical applications

Learn how MCS gained operational efficiency, flexibility, and improved analytics by modernising with SQL Managed Instance.

MCS

Reducing costs and creating new revenue streams

Learn how Epos Now migrated from AWS to SQL Managed Instance and built a new data-as-a-service revenue stream that helps customers save time and benefit from real-time insights.

Epos Now

Migrate to Azure SQL Managed Instance and confidently use your apps

Explore Microsoft partners that offer certified apps for SQL Managed Instance.

Browse apps on Azure Marketplace

Frequently asked questions about Azure SQL Managed Instance

  • When you migrate from SQL Server to Azure SQL Managed Instance, you want to make sure your apps will run in the cloud without the need to make any changes. Having a higher degree of SQL Server engine compatibility, means less refactoring and one less thing to worry about. The degree of compatibility is controlled by database compatibility levels, and SQL Managed Instance is set to the highest compatibility level by default, which is on par with the latest version of the SQL Server engine. In fact, SQL Managed Instance was built on the SQL Server 2016 engine, making it compatible with SQL Server engines ever since. A commitment to not retire older SQL Server engine code also makes SQL Managed Instance backward-compatible with SQL Server engines dating to 2008. Before migrating to SQL Managed Instance, use Azure Migrate or Azure Data Studio to conduct a comprehensive assessment of your data estate to confirm that your databases are ready for the cloud.
  • See the list of supported features. For differences in syntax and behaviour between SQL Managed Instance and on-premises SQL Server, see T-SQL differences.
  • For available hardware generation and service tier characteristics, see the overview of technical characteristics and resource limits.
  • SQL Managed Instance offers the same performance levels per compute and storage size as Azure SQL Database. If you want to consolidate data on a single instance or you simply need a feature supported exclusively in SQL Managed Instance, migrate your data by using export and import (BACPAC) functionality.

Ready when you are – let’s set up your Azure free account

1Savings based on eight vCore Managed Instance Business Critical in East US Region, running 730 hours per month. Savings are calculated from full price (licence included) against base rate (applying Azure Hybrid Benefit for SQL Server), which excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2022, subject to change.

2Price-performance claims based on data from a study commissioned by Microsoft and conducted by Principled Technologies in April 2022. The study compared performance and price performance between a 16 vCore, 64 vCore and 80 vCore Azure SQL Managed Instance using premium-series hardware on the business-critical service tier and the db.m6i.32xlarge, db.r5b.4xlarge and db.r5b.16xlarge offerings for Amazon Web Services Relational Database Service (AWS RDS) on SQL Server. Benchmark data is taken from a Principled Technologies report using recognised standards, HammerDB TPROC-C, HammerDB TPROC-H and Microsoft MSOLTPE, a workload derived from TPC-E. The MSOLTPE is derived from the TPC-E benchmark and as such is not comparable to published TPC-E results, as MSOLTPE results do not comply with the TPC-E Specification. The results are based on a mixture of read-only and update intensive transactions that simulate activities found in complex OLTP and analytics application environments. Price-performance is calculated by Principled Technologies as the cost of running the cloud platform continuously divided by transactions per minute or per second throughput, based upon the standard. Prices are based on publicly available US pricing in South Central US for Azure SQL Managed Instance and US East for AWS RDS as of April 2022 and incorporates Azure Hybrid Benefit for SQL Server, excluding Software Assurance and support costs. Performance and price-performance results are based upon the configurations detailed in the Principled Technologies report.

Can we help you?