
Amazon FSx enables SQL Server deployments on AWS to achieve over 2 million transactions per minute—nearly 3 times higher performance than previous benchmarks—while reducing cost per transaction through innovative multi-filesystem configurations.


<div><p>This article demonstrates how using multiple Amazon FSx file systems can significantly boost SQL Server performance on AWS, achieving over 2 million transactions per minute.</p><ul><li>FSx for Windows File Server achieved 2M+ TPM, nearly 3x better than previous EBS benchmarks</li><li>FSx for ONTAP with SMB protocol distributed primary file group across four file shares</li><li>FSx for ONTAP with iSCSI protocol used RAID-0 striping across four instances</li><li>Multiple FSx filesystems increase total cost but reduce cost per transaction</li><li>x2iedn EC2 instances with 2-4TB RAM outperformed r5dn instances for large databases</li><li>FSx for ONTAP SMB offered best price-to-performance ratio among configurations tested</li><li>Higher RAM reduces IOPS/throughput demand by improving cache hit rates</li></ul><p>Using multiple Amazon FSx file systems provides a cost-effective strategy for high-performance SQL Server deployments on AWS, with comparable or lower per-transaction costs than traditional EBS approaches.</p></div>


Related articles