Best practices for Amazon RDS for SQL Server with Amazon EBS io2 Block Express volumes up to 64 TiB
Database Blog
This article discusses best practices for using Amazon EBS io2 Block Express volumes with Amazon RDS for SQL Server. These volumes support high performance, high throughput, and low latency for demanding database workloads, with up to 64 TiB storage, 4,000 MiB/s throughput, and 256,000 Provisioned IOPS.
Specifically, the article covers:
- Choosing the right RDS DB instance class and storage type based on IOPS, throughput, and capacity requirements
- Migrating SQL Server databases to RDS with io2 volumes using backup/restore
- Modifying existing RDS instances to use io2 volumes
- Managing automated backups and point-in-time recovery for large io2 volumes
- Optimizing backup times with manual snapshots
- Restoring instances from snapshots and lazy loading
- Planning maintenance windows for storage scaling
- Optimizing read replicas and Multi-AZ conversions
- Conclusion with key recommendations for managing large io2 volumes
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Jun 20
2024
2024
Amazon RDS for SQL Server supports up to 64TiB and 256,000 IOPS with io2 Block Express volumes
Jan 31
2025
2025
Amazon RDS Custom for SQL Server supports up to 64TiB and 256,000 IOPS with io2 Block Express volumes
Mar 6
2024
2024
Amazon RDS now supports io2 Block Express volumes for mission-critical database workloads
Dec 18
2024
2024
Optimize Amazon RDS performance with io2 Block Express storage for production workloads
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.