Home icon

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
Go to article

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
Amazon RDS for SQL Server supports up to 64TiB and 256,000 IOPS with io2 Block Express volumes
Jan 31
2025
Amazon RDS Custom for SQL Server supports up to 64TiB and 256,000 IOPS with io2 Block Express volumes
Jul 30
2024
Implementing a fall forward strategy from Amazon RDS for SQL Server Transparent Data Encryption (TDE) and Non-TDE Enabled databases to self-managed SQL Server
Jul 23
2024
Enhance database performance with Amazon RDS dedicated log volumes

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.