Improving storage with additional storage volumes in Amazon RDS for SQL Server

This article explains how to use additional storage volumes in Amazon RDS for SQL Server to overcome the 64 TiB storage limit and optimize database performance and costs.

• Attach up to three additional volumes, extending total capacity to 256 TiB
• Isolate transaction logs on dedicated volumes for improved write performance
• Dynamically add and remove temporary storage volumes as needed
• Optimize performance by assigning different IOPS settings to different volumes
• Reduce costs by selecting appropriate storage classes (gp3, io2) per data type
• Implement multi-tenant storage isolation for accurate per-tenant cost tracking
• Four migration scripts provided: S3 backup/restore, clustered index, new database creation, partitioned tables

The feature enables flexible storage architecture for SQL Server workloads, supporting OLTP systems, data warehouses, and SaaS applications with granular control over performance and costs.