Azure SQL Managed Instance

Modernise your existing applications at scale and do more with a managed, secure and always up-to-date SQL instance in the cloud

Modernise your SQL Server applications to the cloud with ease

Part of the Azure SQL service portfolio, Azure SQL Managed Instance is the intelligent, scalable, cloud database service that combines the broadest SQL Server engine compatibility with all of the benefits of a fully managed and evergreen platform as a service.

With SQL Managed Instance, confidently modernise your existing apps at scale by combining your experience with familiar tools, skills and resources, and do more with what you already have.

The broadest SQL Server compatibility on a fully managed service streamlines app modernisation with minimal code changes

Save up to 55 per cent compared to pay-as-you-go pricing when you re-use your SQL licences with Azure Hybrid Benefit2

Build on the SQL Server code base with the tools and experience you already have

Always operate on the latest version of SQL

SQL Managed Instance is built on the SQL Server engine. It’s evergreen, meaning it’s always up to date with the latest SQL features and functionality. Never worry about updates, upgrades or end of support again.

Learn more

Fully managed and optimised for DBA productivity

Boost productivity and operate more efficiently by letting the service perform time-consuming and complex tasks on your behalf. Features such as built-in high availability, disaster recovery and automated backups ensure that your data is available when you need it, while AI-powered automatic tuning optimises performance for you.

SQL Managed Instance combines all of the best of SQL Server with the financial and operational benefits of platform as a service.

Learn more

Maintain SQL Server application compatibility

Accelerate application modernisation with the latest SQL Server capabilities in the cloud. SQL Managed Instance provides an entire SQL Server instance within a managed service, so you can continue to use familiar tools and SQL Server features such as cross-database queries and linked server.

SQL Managed Instance maintains the highest compatibility levels, so you can move your on-premises workloads without worrying about application compatibility or performance changes.

Learn more

Fully isolate and secure your data

SQL Managed Instance provides two levels of isolation, at the compute level and at the network level, providing a high level of isolation and security for your data.

Compute-level isolation ensures that instances and databases from one customer do not share virtual machines with other customers. Native virtual network support keeps workloads fully contained within a secure virtual network, so you get the benefits of the public cloud while remaining isolated from the public internet.

Learn more

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 managed, secure and always up-to-date SQL instance in the cloud

Explore all SQL Managed Instance pricing options and find the performance that fits your workload.

Trusted by companies of all sizes

Achieve breakthrough performance and savings

Learn how Komatsu Australia reduced costs by 49 per cent and increased performance up to 30 per cent by migrating their data to SQL Database Managed Instance.

Komatsu

SQL Managed Instance supports growth and flexibility

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

Descartes

Migrate workloads, minimise downtime and code changes

Learn how KMD, part of NEC corporation, migrated an 8-terabyte production database to Azure SQL Managed Instance quickly and without service interruption.

KMD

Collaborate with agility on Azure

Baltika Breweries’ document management system is based on Azure SQL Managed Instance. See how migrating to a scalable platform as a service offering helped them meet their goals for resource elasticity and low administrative overhead.

Baltika Breweries

Cloud-first approach enables growth without compromise

Learn how PowerDETAILS migrated to Azure SQL Managed Instance and achieved the scale and capacity they needed for future growth.

PowerDETAILS

Reduce costs and create new revenue streams

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

Epos Now

Migrate your data to Azure SQL Managed Instance and confidently use your apps

These are some of the ISV partners who have certified their apps for Azure SQL Managed Instance.

Learn more about the apps

Documentation, training and migration resources

Migrate to SQL Database

Get started straight away with the Azure Migration Center.

Documentation

Explore tutorials, samples, FAQ and other documentation to learn how to use SQL Managed Instance.

Microsoft Learn

Expand your knowledge and earn certifications with hands-on online courses.

Frequently asked questions about Azure SQL Managed Instance

  • See a list of supported features on Managed Instance in our documentation.

    For differences in syntax and behaviour between Azure SQL Managed Instance and on-premises SQL Server, see T-SQL differences from SQL Server.

  • For available hardware generation and service tier characteristics, see our 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 Managed Instance, you can migrate your data by using export and import (BACPAC) functionality.
  • The Azure Hybrid Benefit for SQL Server helps you maximise the value from your current licensing investments and accelerate your migration to the cloud. Azure Hybrid Benefit for SQL Server is an Azure-based benefit that enables you to use your SQL Server licences with active Software Assurance to pay a reduced rate (“base rate”) on vCore-based Azure SQL Database and Azure SQL Managed Instance. You can apply this benefit even if the SKU is active, but the base rate will be applied from the time you select it in the portal. No credit will be issued retroactively.

    You can activate the Azure Hybrid Benefit via the Azure Portal by confirming that you have sufficient active licences with Software Assurance.

    The Azure Hybrid Benefit for SQL Server provides:

    • The ability to move your licences to a fully managed platform as a service (PaaS) product. Azure is the only cloud that provides this ability. Amazon Web Services Relational Database Service (RDS) is not eligible for bring-your-own-licence (BYOL) and must be offered as “licence-included”.
    • Four cores in the cloud for every one core on premises for Enterprise edition customers in the general purpose or Hyperscale service tiers.
    • 180 days of dual-use rights to apply to current deployment (on-premises or on third-party cloud) and in Azure to allow for data migration.
  • SQL Managed Instance allows for scaling compute and storage independently. Customers pay for compute measured in vCores, storage and backup measured in gigabytes (GB).

    SQL Managed Instance has two price options:

    • Licence included: Excludes Azure Hybrid benefit for SQL Server. This option is for customers who choose not to apply their existing SQL Server licences with Software Assurance to Managed Instance.
    • Base rate: Reduced price that includes Azure Hybrid Benefit for SQL Server. Customers can opt into this price by using their SQL Server licences with Software Assurance.

    Backup storage is also charged separately, with the backup cost dependent upon the size of the database, the rate of change and the configured retention period. The backup storage amount is equal to the allocated data storage for the instance and is provided at no extra charge. Additional backup storage consumption will be charged in GB per month and will depend upon the workload and size of the individual databases.

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

Start now

1Results are for a composite organisation based on interviewed customers. “The Total Economic ImpactTM of Migration to Microsoft Azure SQL Managed Databases”, a commissioned study conducted by Forrester Consulting on behalf of Microsoft, March 2020.

2Savings based on eight vCore Managed Instance Business Critical in East US Region, running for 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 February 2020, subject to change.