There are three options available to you when initializing a SQL Server instance in the Azure Cloud. The most recently announced option is the SQL Database Managed Instance, which was made publicly available at the start of Q3-2019 on the Azure Cloud.
What is a Managed Instance, and should you choose it over Single or Elastic Pool options in the Azure Cloud?
A SQL Managed Instance is a new service offering from Microsoft that provides almost full compatibility with the latest on-premise version of the SQL Server Database Engine.
Managed Instances are great for businesses looking to migrate their database to a fully-managed Platform as a Service (PaaS) environment in the Azure cloud. The Azure Data Migration Service (DMS) allows you to quickly initialize a highly-compatible cloud SQL database with native VNet support. Microsoft also has its Software Assurance program, where you can get a discounted rate on licensing fees by using the Azure Hybrid Cloud Benefit.
Since a Managed Instance is offered through the Azure Cloud, you get many Platform-as-a-Service (PaaS) benefits compared to on-premise SQL instances, including:
For business-critical and general workloads, Microsoft offers a 99.99% uptime service level agreement. In addition to this, they also have automated backup scheduling with configurable retention periods. These backups also allow you to go back to a specific date and time using Microsoft’s Point-in-time restore.
One of the most prominent features of Managed Instances is the new SQL Azure VNet compatibility. Instead of running on a public endpoint like Single and Elastic Pools, you get a private IP address on the Azure VNET, which you can connect to via your corporate VPN. This allows you to create tunneled connections from your office to your cloud network, offering transparent data encryption (TDE) and more security compared to Single or Elastic Pools.
Much like Single SQL instances, Managed Instances allow for quick and easy migration to the cloud.
The simplest way to migrate your database is through backing up your on-premise environment, and uploading it to a SQL Server Managed Instance via Azure Blob storage. From here, you can restore the backup on the cloud SQL Server instance and have a fully functioning replica of your on-premise deployment.
A Managed Instance of SQL Server in the cloud treats compute and storage components separately:
This offers a good balance between cost, reliability, and performance when using a SQL Server Managed Instance.
There are also options for faster storage with Managed Instances. If your SQL Database workloads require less than 1ms of storage latency, you may opt for an Ultra Disk. These disks can range from 4GB to 64TB in size and have a maximum throughput of 2000MB/s.
Trianz is a leading Microsoft Azure Managed Service Partner. We take pride in our human-first approach to IT consulting, offering 24/7 support on the Microsoft Azure Cloud via Concierto Cloud, an award-winning IP-based cloud management platform. Migrating to the cloud requires comprehensive planning and foresight, so consult with Trianz today and start your Azure migration journey.
Visit www.trianz.com/cloud to learn more about Azure, or get in contact today for a consultation using the form below!
Contact Us Today
In the data-sensitive modern age, security should be at the forefront of every business’s IT strategy. With massive quantities of information being transmitted across the internet, there can be severe repercussions for companies that neglect best practices when it comes to cybersecurity.Explore
With a universal emphasis on digital transformation, IT workloads are constantly increasing for every organization. There is more to do than there is even talent available to do it, and CTOs and Directors of IT are responding by turning to sophisticated automation.Explore
One of the most challenging aspects of working in business operations is the corporate response to changing objectives, which may feel to employees like unending directional shifts. Improving processes and effectively responding to rapidly evolving customer needs requires a high degree of adaptability.Explore
The latest market trends indicate that enterprises will invest the most on digital transformation technologies that support operating model innovations. These investments will help enterprises focus on making business operations more responsive and effective by leveraging digitally-connected products/services, assets, people, and trading partners.Explore