Rehost your SQL Server to Azure Virtual Machines for manageability and cost optimization
Running SQL Server on Azure Virtual Machines provides a suite of free manageability capabilities that are available only on Azure, and which make it easier to run in a cost effective, secured and optimized manner. Microsoft introduced the Azure SQL family of database services to provide customers with a consistent, unified experience across an entire SQL portfolio and a full range of deployment options from edge to cloud. As a SQL Server customer, you can migrate your SQL workloads to SQL Server on Azure Virtual Machines while making the most of your current SQL Server license investments and benefit from the manageability benefits that SQL Server virtual machines offer today. Running SQL Server on an Azure virtual machine provides the best lift-and-shift experience for workloads where OS-level access is required. A SQL Server instance on an Azure Virtual Machine is the cloud equivalent of an on-premises SQL Server, running your mission critical applications on Azure. Azure offers unique Windows Server and SQL Server licensing benefits through Azure Hybrid Benefit, giving you the ability to run the same SQL Server with a better total cost of ownership (TCO), with low effort and great performance. Azure also offers that ability for you to automatically manage your Windows Servers using our recently announced Azure Automanage preview offering. Read more about it here. How can you leverage these benefits? All of the security, manageability and cost-optimization benefits mentioned above are enabled through the SQL Server IaaS Agent Extension. You can enable the SQL Server IaaS Agent extension at a subscription level for all your SQL Server virtual machines using a simple button on the Azure Portal. To ensure that you’re receiving full manageability benefits, this extension can be installed on a SQL Server virtual machine that is already running or any new SQL Server virtual machine that you create in the future. The screenshot below shows the different manageability options that are enabled when the SQL Server IaaS extension is enabled. Optimize Cost The SQL Server IaaS extension enables administrators to reduce cost and manage inventory with less effort. There are a number of cost optimization capabilities that a SQL Server administrator can leverage with SQL Server virtual machines which are made possible through our “License type” feature. As an administrator, you will have the ability to: See all your SQL Server virtual machine deployments in a single dashboard to make inventory management easier Get a snapshot of how many SQL Server on Azure Virtual Machines are leveraging Azure Hybrid Benefit Switch between Pay-as-you-go and Azure Hybrid Benefit licensing models to optimize the use of your licenses in the cloud Leverage FREE passive SQL Server core benefits that enable using Azure as a Disaster Recovery site for your on-premises SQL Server at no additional license cost for customers with Software Assurance or SQL Server subscription licenses Leverage FREE passive SQL Server core benefits for High Availability and Disaster Recovery scenarios for primary replicas hosted in Azure for customers with Software Assurance or SQL Server subscription licenses Run SQL Server Reporting Services virtual machines with Pay-as-you-go licensing or Azure Hybrid Benefits The License type for a SQL Server virtual machine provides three options: Pay As You Go, Azure Hybrid Benefit and Disaster Recovery (as seen in the screenshot below). The Disaster Recovery toggle gives you the ability to leverage the free Disaster Recovery license type benefit without having to track the deployments separately, making license management and inventory a lot easier. This benefit applies to all releases of SQL Server starting from SQL Server 2008 to SQL Server 2019 as long as you are using licenses covered with Software Assurance or subscription licenses. You can learn more about these benefits here. As a SQL Server user, you will have the ability in the near future to deploy a SQL Server Reporting Services virtual machine for your BI reporting requirements and also leverage a flexible licensing model through Pay-as-you-go and Azure Hybrid Benefit licensing. Also, you can deploy your Power BI Report Server virtual machines with Azure Hybrid Benefit licenses which makes it easier to rehost your relational and reporting workloads into Azure. Enhance Security Security is a key area of interest for any database administrator who is responsible for securing and protecting business data stored in a SQL Server database. Sometimes compliance requirements drive security needs like encryption of data at rest. SQL Server on Azure Virtual Machines make security management easier through patching and easily implement encryption features for better security and compliance. The Automated Patching feature allows a SQL Server administrator to select a maintenance window schedule for applying Important Windows Server and SQL Server updates that are distributed through the Windows Update channel. You have the ability to select the maintenance window duration and the start of the window. In addition to the above benefits, SQL Server on Azure virtual machines also offer you the ability to detect anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases. You'll see alerts when there are suspicious database activities, potential vulnerabilities, or SQL injection attacks, and anomalous database access and query patterns. Read more about Azure Defender for SQL Server. Extended support for SQL Server 2008 and SQL Server 2008 R2 ended on July 10, 2019. Customers that have SQL Server 2008 R2 and SQL Server 2008 can upgrade to a newer version of SQL Server or migrate to Azure SQL Database or Managed Instance. There is also an option for customers to stay protected using Extended Security Updates for SQL Server 2008 or SQL Server 2008 R2. This is available for Free and enabled by default when migrating on-premises servers to SQL Server on Azure virtual machines. This provides you the ability to receive a critical security update when one is released or receive technical support for SQL Server 2008 or SQL Server 2008 R2 with your existing support plan without having to purchase Extended Security Update subscriptions. The SQL connectivity feature allows you to do the following: Set the port for the SQL Server instance to ensure that you are able to listen on another port other than a well-known port. Configure the connectivity rules to make it as restrictive like allowing local connectivity only or opening it up to public internet for external applications and clients to connect to the SQL Server instance (see screenshot below). Enable SQL Authentication for the SQL Server instance if your applications and users require this authentication method. Configure Azure Key Vault for the SQL Server instance to leverage Key Vault for Transparent Database Encryption, Column Level Encryption and Always Encrypted features of SQL Server to enable encryption of data at rest and in motion. Increase Uptime SQL Server virtual machines provide various management capabilities to make configuration of the environment a lot easier for business continuity and disaster recovery scenarios. The new High Availability feature allows you to create a new cluster or onboard an existing cluster, and then create the availability group, listener, and internal load balancer. Additionally, SQL Server on Azure Virtual Machines also help you reduce your cost of deploying a highly available environment if you have Software Assurance or you are using SQL Server subscription licenses. Let us consider an example where you were running a SQL Server virtual machine topology having one primary replica, one synchronous passive secondary replica and one asynchronous passive replica. You would need to license only the primary replica. It is assumed that the number of cores on all three replicas are the same. The example below uses Always On Availability Group as the High Availability and Disaster Recovery feature, but you can leverage this benefit with other SQL Server features like Failover Cluster Instances, Log Shipping, Database Mirroring and Backup and Restore. More details available here. The Automated Backup feature allows you to setup SQL Server backups with various options like encrypting backups, set a retention period, backup system databases, configuring a manual backup schedule or setting up an automated backup. This is great for SQL Server virtual machines where you don’t want to attach a backup software but just backup all the databases on the instance to support point-in-time restore for creating copies of the database environment or to recover from user errors. Manageability SQL Server on Azure Virtual Machines provides a number of free manageability benefits which make administration tasks for a SQL Server instance a lot easier. In addition to that a number of best practices are surfaced through the wizards to make SQL Server virtual machines run with the most optimal configurations. SQL Server on Azure Virtual Machines provides the ability to simplify storage configuration while setting up the virtual machine through the use of pre-configured storage profiles as seen in the screenshot below. This ensures that you are picking the right storage configuration for your data, log and tempdb files. You can read more about it here. Once the SQL Server virtual machine is running, you have the option of increasing the storage capacity of your disks and the wizard will help you determine if you are picking a configuration setting which could be the victim of a capacity limit (see highlighted section in screenshot below). You also have the ability to manage your SQL Server virtual machines through the SQL Server IaaS extension through the use of Azure CLI or PowerShell. Azure Runbooks or Azure Automation scripts can be created to leverage these benefits at scale across a fleet of SQL Server virtual machines. If you leverage in-database Machine Learning for your SQL Server instances, SQL Server virtual machines provide the ability to configuring advanced analytics for your instance. Next Steps Running SQL Server in an Azure virtual machine gives you the same capabilities and experience you are used to with on-premises SQL Server, plus the additional ease of use and management benefits available only on Azure. Ensure that your virtual machines are running the SQL Server IaaS Extension to enable all these benefits, and check out the following links for more information about running SQL Server in Azure virtual machines. Register a SQL Server VM in Azure with the SQL Server IaaS extension Manage SQL Server VMs in Azure by using the Azure portal Learn more at the digital event: Transform Your Applications with Azure SQL
Benefit from Resource Provider registration when self-installing SQL Server on Azure Virtual Machine
If you choose to self-install SQL Server on Azure Virtual Machines instead of choosing a preconfigured pay-as-you-go or bring-your-own-license from the Azure Marketplace, there are two reasons why you should register your SQL VM with our Resource Provider today: Compliance – satisfy the Microsoft Product Terms requiring you to indicate to Microsoft when using Azure Hybrid Benefit. Feature benefits – unlock auto-patching, auto-backup, monitoring, and manageability capabilities, as well as licensing flexibility, when registering with SQL virtual machines with Resource Provider. Previously, these were only available to SQL VM images from the Azure Marketplace.SQL Server on Azure VMs - the best price-performance gets even better!
As we reflect on the past year and look toward what’s to come in 2023, we thought it would be a great time to call attention to all the innovations in the price-performance area for SQL Server on Azure Virtual Machines that came out this past year, and to announce we are starting the new year with a bang in the form of an all-new price-performance study from GigaOm!Lift and Shift Always On SQL Server Failover Cluster Instance (SQL FCI) to Azure VMs
Today, we are announcing two new features enabling lift and shift of Always On SQL server Failover Cluster instances (SQL FCI) from on-premises to Azure Virtual Machines: Distributed Network Name (DNN) for SQL FCI and Azure Shared Disks for SQL FCI.Optimize OLTP Performance with SQL Server on Azure VM
Most of you are running OLTP applications today with read heavy and complex transactions. The TPC-E benchmark is a reliable representation of modern OLTP workloads and highly recommended to measure OLTP workload performance. The TPC-E benchmark uses diverse transactions and utilizes wide range of data types with 12 transactions acting on 33 tables all exercising the ACID compliance tests. These transactions cover traditional OLTP processing along with some very light analytic queries. In this article, we will share recommendations to optimize SQL Server performance on Azure VMs based on performance testing with scaled down TPC-E [1] benchmark.Announcing Performance Optimized Storage Configuration for SQL Server on Azure VMs with SQL VM RP
Today, we are excited to announce Performance Optimized Storage Configuration capabilities for the VM’s registered with SQL VM RP. This feature automates storage configuration according to performance best practices for SQL Server on Azure virtual machines through Azure Portal or Azure Quick start Templates when creating a SQL VM. Automated performance best practices include separating Data and Log files, cache configuration for premium disks hosting data and log files, support for Temp DB on local disk, support for Ultra disks to host data, log or Temp DB files and database engine only images. In this article, we will discuss each automated performance best practice in detail.How to get the biggest bang for your buck with SQL Server on Azure VMs
Running SQL Server on an Azure virtual machine is one of the quickest and easiest ways to lift-and-shift your SQL workloads into the cloud. In this blog, we’re going to cover three key aspects to right-sizing (and right-configuring) your Azure VM in order to get the best price-performance possible when migrating SQL Server workloads to Azure VM.Optimize TCO with new SQL Server Software Assurance Benefits for Disaster Recovery
Software Assurance (SA) Benefits for SQL Server are enhanced on November 1 st, 2019 with new rights to build a holistic high availability and disaster recovery plan for SQL Server workloads. Enhanced SA rights for SQL Server enable significant licensing cost savings for SQL Server both for on-premises and on Azure VMs. In this blog post, we will highlight the scenarios to maximize savings with new SA benefits for SQL Server.SQL Server on Azure VM - Now with 30% better price-performance on the new Ebdsv5 VM series!
The new Ebdsv5 VM series in preview starting today offers the highest I/O throughput to core ratio in Azure and is ideal for SQL Server workloads and other I/O-heavy workloads like Oracle, Teradata, and SAS. Once the Ebdsv5 series is generally available we expect it to be the flagship Azure VM for SQL Server workloads.
