Posted On: Jan 27, 2021
Starting today, you can launch Amazon Relational Database Service (Amazon RDS) for SQL Server on Amazon EC2 R5d and Amazon EC2 M5d instance types with tempdb configured to use local instance storage. By placing tempdb data files and log files locally, you can achieve lower read and write latencies when compared to the standard EBS based offerings.
Amazon EC2 R5d and Amazon EC2 M5d instance types provide up to 3,600 GiB of Non-Volatile Memory Express (NVMe) SSD-based instance storage optimized for low latency, very high random I/O performance, and high sequential read throughput. When provisioning either instance type, Amazon RDS for SQL Server automatically places tempdb files on the locally attached NVMe disks, achieving low storage latencies and improving performance for certain workloads by up to 30%.