As a part of our dedication to making sure that Microsoft Azure is the very best place to run SQL Server and Home windows Server, Microsoft is happy to announce that SQL Server on Azure Digital Machines simply achieved new, sooner efficiency benchmarks than ever earlier than. In line with a report from analyst agency GigaOm, clients can get mission-critical efficiency for SQL Server on Azure Digital Machines as much as 57 % sooner and costing as much as 54 % much less than AWS EC2 on a price-performance foundation, with Azure Hybrid Profit and a three-year dedication.1 As Pam Lahoud wrote, this regular improve in efficiency and worth is the results of an ongoing collection of investments within the core Azure infrastructure, together with the Ebdsv5 digital machine (VM) collection which are optimized in your database workloads and new Premium SSD v2 Disk Storage that brings you quicker efficiency than earlier than, as much as 70 % sooner than a yr in the past. However nice {hardware} isn’t all we’ve got in your SQL Server—Azure additionally has unmatched value gives, distinctive Home windows Server and SQL Server manageability options, and instruments and applications to get your workload to the cloud.
Azure offers essentially the most worth in your Home windows Server and SQL Server workloads with distinctive capabilities and gives that assist you to save prices, time, and scale back complexity to do extra with much less. You possibly can save as much as 85 % over the usual pay-as-you-go price leveraging Home windows Server and SQL Server licenses with Azure Hybrid Profit when migrating to Azure digital machines. Not solely can we assist you to save whenever you transfer, however we need to assist you to optimize your workloads in Azure. You will get essentially the most out of Azure on an ongoing foundation with suggestions to optimize your workloads and prices with Azure Advisor.
As well as, clients should buy Azure Reserved Digital Machine Cases to lock in the very best pricing on a selected digital machine occasion collection for a one- or three-year interval. Should you want flexibility for dynamic workloads, take into account the brand new Azure financial savings plan for compute, a versatile pricing mannequin that unlocks financial savings whenever you decide to spending a set hourly quantity on choose compute providers for one or three years. Save no matter area, occasion collection, or working system. Study extra within the Azure saving plan for compute announcement weblog.
Azure offers unmatched manageability for Home windows Server and SQL Server. By registering your SQL Server on Azure Digital Machines with SQL IaaS Agent Extension, you may entry a plethora of advantages: decrease complete price of possession (TCO), sturdy and easy excessive availability/catastrophe restoration (HA/DR), and built-in and free safety and manageability. Registering SQL Server digital machines lets you change between pay-as-you-go licenses or utilizing Azure Hybrid Profit to carry SQL Server licenses from on-premises to Azure straight throughout the Azure portal. Registration additionally simplifies the complicated administrative process of All the time On availability group deployment and lets you use the catastrophe restoration license sort, which is included along with your Azure Hybrid Profit or pay-as-you-go licensed main SQL Server occasion. Non-obligatory automated backup may be configured with backup encryption, configurable retention interval, and customized backup schedules. You too can arrange automated SQL Server safety updates inside customer-defined upkeep home windows and straightforward configuration of database encryption by Azure Key Vault integration, each of which let you handle your patching to raised meet your safety and compliance wants.
Save hours of day-to-day IT overhead for Home windows Server functions and information by simplifying IT administration with Azure Automanage. Additional improve effectivity and workload uptime by reboot-less patching of Home windows Server VMs with Hotpatch, out there solely on Azure.
Azure has digital machine and storage {hardware} designed in your most important SQL Server workloads. Azure Ev5 VMs are designed for memory-intensive, business-critical functions, relational database servers, and in-memory information analytics workloads. The Ebdsv5 collection of VMs, a part of the Ev5 household, are perfect for database and different I/O-intensive workloads as a result of they provide greater distant storage throughput and IOPS per vCPU than every other VM collection in Azure. We not too long ago added to this lineup Azure Premium SSD v2, the following technology of Premium SSD Disk Storage that gives essentially the most superior general-purpose block storage answer with the very best value efficiency. Premium SSD v2 gives sub-millisecond disk latencies for demanding IO-intensive workloads at a low price.
Azure has nice locations for modernizing SQL Server. Azure SQL Managed Occasion is a managed, all the time up-to-date SQL occasion within the cloud, and it makes an amazing vacation spot for database modernization in Azure. It has nice efficiency as properly: as I’ve talked about beforehand, SQL Managed Occasion has as much as 5 occasions sooner efficiency whereas costing as much as 93 % lower than AWS RDS.2 Spend extra time innovating and fewer time patching, updating, and backing up your databases and understand as much as 40 % sooner time to worth.3 The hyperlink function of Azure SQL Managed Occasion connects SQL Servers hosted wherever (supporting SQL Server 2019 and SQL Server 2022) to Azure SQL Managed Occasion, offering hybrid flexibility and database mobility. Utilizing close to real-time information replication to the cloud, shift workloads to read-only secondaries on Azure to make the most of cloud-only options, efficiency, and scale. You too can select emigrate a number of functions on the similar time, at your individual tempo, with minimal downtime.
Azure gives free instruments earlier than, throughout, and after migration. Automate the transfer, acquire rightsizing insights to drive efficiencies, and keep optimized after the transfer: Azure Migrate and Azure Database Migration Service present built-in discovery, evaluation, migration, and modernization capabilities for SQL Server and Home windows Server workloads, together with extensibility options for ISV software integration. Cut back your migration prices and speed up your journey with skilled help from Microsoft and companions by the Azure Migration and Modernization Program. The brand new Microsoft SQL + Apps Migration Manufacturing unit Program can assist you assess and migrate qualifying low-complexity SQL Server and Home windows Server functions and databases to Azure for gratis to you.4
Getting began with SQL Server on Azure
- Learn the full benchmark report for SQL Transaction Processing and Analytic Efficiency Worth-Efficiency Testing.
- Watch and be taught with Microsoft Mechanics: Best choice for Database Migration into Azure.
- Study extra about saving time and enhancing safety by registering your SQL Server on Azure Digital Machines from this datasheet and our documentation.
- Speed up your modernization with our on-demand webinar: The best way to Migrate SQL Server from VM to SQL Managed Occasion.
1 Worth-performance claims based mostly on information from a research commissioned by Microsoft and performed by GigaOm in January 2023. The research in contrast value efficiency between SQL Server 2019 Enterprise Version on Home windows Server 2022 in Azure E32bds_v5 occasion sort with Premium SSD v2 disks and SQL Server 2019 Enterprise Version on Home windows Server 2022 in Amazon Net Companies Elastic Cloud Compute occasion sort r5b.8xlarge with Normal Objective (gp3) volumes. Benchmark information is taken from a GigaOm Transactional Discipline Take a look at derived from a acknowledged trade commonplace, TPC Benchmark™ E (TPC-E) The Discipline Take a look at doesn’t implement the complete TPC-E and as such shouldn’t be corresponding to any revealed TPC-E benchmarks. Costs are based mostly on publicly out there US pricing in East US for SQL Server on Azure Digital Machines and Oregon for AWS EC2 as of January 2023. The pricing incorporates three-year reservations for Azure and AWS compute pricing, and Azure Hybrid Profit for SQL Server and Home windows Server, and License Mobility for SQL Server in AWS, excluding Software program Assurance and help prices. Precise outcomes and costs might differ based mostly on configuration and area.
2 Worth-performance claims based mostly on information from a research commissioned by Microsoft and performed by Principled Applied sciences in April 2022. The research in contrast efficiency and value efficiency between a 16 vCore, 64 vCore and 80 vCore Azure SQL Managed Occasion utilizing premium-series {hardware} on the business-critical service tier and the db.m6i.32xlarge, db.r5b.4xlarge and db.r5b.16xlarge choices for Amazon Net Companies Relational Database Service (AWS RDS) on SQL Server. Benchmark information is taken from a Principled Applied sciences report utilizing acknowledged requirements, 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 shouldn’t be corresponding to revealed TPC-E outcomes, as MSOLTPE outcomes don’t adjust to the TPC-E Specification. The outcomes are based mostly on a mix of read-only and replace intensive transactions that simulate actions present in complicated OLTP and analytics software environments. Worth-performance is calculated by Principled Applied sciences as the price of operating the cloud platform constantly divided by transactions per minute or per second throughput, based mostly upon the usual. Costs are based mostly on publicly out there US pricing in South Central US for Azure SQL Managed Occasion and US East for AWS RDS as of April 2022 and incorporates Azure Hybrid Profit for SQL Server, excluding Software program Assurance and help prices. Efficiency and price-performance outcomes are based mostly upon the configurations detailed within the Principled Applied sciences report. Precise outcomes and costs might differ based mostly on configuration and area.
3 Outcomes are based mostly on clients interviews. “The Financial Worth of Migration On-premises SQL Server Cases to Microsoft Azure SQL Options,” a commissioned research performed by The Enterprise Technique Group on behalf of Microsoft, October 2020.
4 Topic to the constraints described within the full SQL + Apps Migration Manufacturing unit program specs right here, and supplied that the SQL Server workloads are low complexity with no code modifications, Microsoft agrees to evaluate and migrate SQL Server databases and SQL Server-associated functions out of your datacenter or AWS EC2 to Azure for gratis to buyer. Migrations should be accomplished by June 30, 2023.
