Microsoft Workloads on AWS

Tag: Amazon FSx

Optimizing large-scale migration of SQL Server databases to Amazon EC2 using backup metadata

In this blog post, we explore how the Microsoft SQL Server backup metadata, known as backup headers, can be leveraged when migrating from on premises to Amazon Elastic Compute Cloud (Amazon EC2). This technique is particularly useful when access to source database information is non-existent or only backup files are available with no access to […]

Scaling SQL Server performance beyond 1M transactions per minute with Amazon FSx

In this blog post, we introduce a strategy for scaling Microsoft SQL Server deployments on Amazon Web Services (AWS) that uses Amazon FSx, a service that provides fully managed, high-performance file systems in the cloud. This strategy increases SQL Server performance on AWS, providing 2 to 3 times as many Transactions per Minute (TPM) as […]

Do AWS customers benefit from 64KB block size for SQL Server storage?

In this blog post, we will share results of Microsoft SQL Server performance testing using Amazon FSx for Windows File Server (Amazon FSx) and Amazon Elastic Block Store (Amazon EBS) with block sizes in the range of 16 KB to 64 KB to prove or disprove the common opinion that SQL Server requires 64KB block […]

Amazon FSx for Windows File Server and AWS Managed Microsoft AD Multi-Administrator Deployment

In this blog post, I will demonstrate how to configure your Amazon FSx for Windows File Server and AWS Managed Microsoft Active Directory (AD) to give separate teams administrative control over each individual Amazon FSx for Windows File Server. I was working with a customer that deployed Amazon FSx for Windows File Server with AWS […]