Microsoft Workloads on AWS

Tag: HAQM FSx

Optimizing large-scale migration of SQL Server databases to HAQM 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 HAQM Elastic Compute Cloud (HAQM 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 HAQM FSx

In this blog post, we introduce a strategy for scaling Microsoft SQL Server deployments on HAQM Web Services (AWS) that uses HAQM 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 HAQM FSx for Windows File Server (HAQM FSx) and HAQM Elastic Block Store (HAQM 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 […]

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

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