Microsoft SQL Server on AWS
Customers have been running Microsoft Workloads on AWS for over 12 years, longer than any other cloud provider. Customers choose AWS because we have the most experience with Microsoft applications in the cloud and we offer the best platform for Windows Server and SQL Server in these areas: higher performance and reliability, greater security and identity services, more migration support, the broadest and deepest capabilities, lower total cost of ownership, and flexible licensing options. AWS supports everything you need to build and run Windows applications including Active Directory, .NET, Microsoft SQL Server, Windows desktop-as-a-service, and all supported versions of Windows Server. With our proven expertise, we can help you easily lift-and-shift, refactor, or even modernize your Windows workloads.
Click here to learn What’s New with SQL Server on AWS.
Why SQL Server on AWS
AWS has the broadest global infrastructure with 77 Availability Zones (AZ) across 24 regions and 99.99% availability for each Amazon EC2 region. By moving your SQL Server workloads to AWS, customers can realize a 98% reduction in unplanned downtime, 71% faster deployment, and 26% higher developer productivity, per IDC. AWS also delivered 2x better performance and 62% lower cost for a SQL Server workload on an EC2 R5b.8xlarge instance when directly tested against the next largest cloud provider, per Principled Technologies.
AWS offers 230 security, compliance, and governance services and features, 3x more services than the next largest cloud provider. With the AWS Nitro System, the underlying platform for EC2 instances, we provide you with enhanced security that continuously monitors, protects, and verifies instance hardware and firmware, minimizing the attack surface from vulnerabilities and external threats. We offer AWS Managed Active Directory securely in the cloud eliminating the need for you to synchronize or replicate data from your existing Active Directory during migrations. With AWS Identity Services, you can also manage identities and permissions at scale, while providing flexible options for where and how you manage your employee, partner, and customer information.
AWS has unmatched experience helping millions of organizations reach their migration goals faster through unique tools and services. With Amazon Database Migration Service, AWS has helped customers migrate over 230,000 databases to AWS. The Migration Acceleration Program (MAP) for Windows provides best practices, tools and incentives to reduce the complexity and cost of migrating to the cloud with support from AWS Partners and Professional Services.
AWS offers over 350 Amazon EC2 instances where comparable services are simply not available from other cloud providers. We provide the only fully managed services for native-Windows file system with Amazon FSx for Windows File Server, enabling you to simplify management overhead and reduce costs. Amazon Elastic Block Store offers 99.999% availability, 99.999% durability, and performant block storage for your most demanding SQL Server deployments. Customers also choose AWS for the best and most consistent networking performance for Microsoft applications, delivering 3x more throughput and 25% lower latency than the next cloud provider.
Customers can accelerate growth, drive efficiencies, and realize long-term cost reductions running SQL Server on AWS. Customers can reduce 5-year cost of operations by 56% and gain 37% lower infrastructure costs, delivering up to 442% ROI over 3 years, per IDC. AWS also offers customers more ways to save through unique pricing models such Savings Plans, which provide you with savings up to 72% on Amazon EC2 instances. Amazon EC2 Spot reduces costs by up to 90% on compute instances for fault tolerant workloads.
We offer the most options for using new and existing Microsoft software licenses on AWS. By purchasing Amazon Elastic Compute Cloud (Amazon EC2) or Amazon Relational Database Service (Amazon RDS) license-included instances, you get new, fully compliant Windows Server and SQL Server licenses from AWS. You can bring your existing licenses to AWS with Amazon EC2 Dedicated Hosts, Amazon EC2 Dedicated Instances, or EC2 instances with default tenancy using Microsoft License Mobility through Software Assurance. AWS License Manager makes it easier to track the usage of software licenses and reduce the risk of non-compliance.
Estimate cost savings from migrating SQL Server workloads to AWS
The AWS Pricing Calculator helps you estimate your total cost of ownership for running SQL Server workloads on AWS based on service configurations you need for your business. You can include pricing for support costs, Dedicated Hosts on EC2, RDS for SQL Server cost modeling, and flexible pricing options such as Savings Plans in your estimate.
Achieve better price-performance for your SQL Server workloads
You can gain faster performance at lower cost for your Windows and SQL Server workloads on AWS. A recent benchmark by Principled Technologies showed that an EC2 R5b.8xlarge instance delivered 2x the performance & 62% cost savings for a SQL Server workload, when directly tested against the next largest cloud provider.
How AWS helps you migrate and modernize SQL Server workloads
Assess your cloud readiness before you migrate
AWS can help you assess your readiness to move to cloud. With AWS Optimization and Licensing Assessment (AWS OLA), you can make data-driven migration decisions based on actual resource utilization, third-party licensing, and application dependencies. AWS OLA provides right-sized and licensing-optimized instance recommendations for your on-premises SQL Server workloads, including opportunities for Reserved Instances, optimized CPUs, Dedicated Hosts, and Microsoft BYOL options.
Migrate with AWS programs
Customers looking to migrate SQL Server workloads with AWS can take advantage of AWS programs for migration. With our APN Partner and Professional Services teams, AWS Migration Acceleration Program (MAP) for Windows provides services, best practices, and tools to help our customers save costs and accelerate your migrations on AWS.
Optimize Windows workloads after you migrate
After moving your SQL Server workloads onto AWS, you can continue optimizing your costs, usage, and licenses to suit your business needs. With AWS Cost Explorer, you can visualize, understand, and manage your AWS costs and usage over time to take control of spend. AWS Compute Optimizer recommends optimal AWS Compute resources for your workloads so that you can reduce costs up to 25% by analyzing historical utilization data. AWS Managed Services can help operate your cloud environment post-migration by analyzing alerts and responding to incidents, reducing operational overhead and risk. You can use AWS Systems Manager to automate operational tasks across your AWS resources and better manage your infrastructure at scale.
AWS can also help you modernize your Windows-based applications with AWS open source services when you’re ready to break free from the high costs of commercial licensing. We offer the widest range of options to include running SQL Server database applications on EC2 Linux, moving workloads to Amazon Aurora, containerizing your Windows applications with Amazon EKS, going serverless with AWS Lambda, or leveraging a micro-services based architecture.
Easy to use, high-performance block storage for SQL Server
Amazon Elastic Block Store (EBS) with new Amazon EC2 R5b instances provides easy to use, high-performance block storage for Microsoft SQL Server. Benefit from the highest block storage performance with a single storage volume using io2 Block Express (Preview) and EC2 R5b. Other SSD-backed EBS options include io2 volumes for business-critical applications and gp3 volumes for general purpose applications. Amazon EBS also offers crash-consistent snapshots and enables application consistent snapshots through Windows VSS (Volume Shadow Copy Services) to help protect your SQL Server deployments.