Amazon RDS for SQL Server now supports tempdb on local instance store with R5d and M5d instance types
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.
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%.
Amazon RDS for SQL Server makes it easy to set up and scale SQL Server databases in the cloud. To get started, please see the Amazon RDS for SQL Server user guide. For pricing and regional information, please refer to the Amazon RDS for SQL Server pricing page.