AWS – 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.
Read More for the details.