• The read latency is 32 ms & write latency is 95 ms for tempdb data file & for tempdb log file it is 8 for read & 45 for write latency. I tried to find out the baseline calculation to get the good or bad read/write latency but the generic answer is “it depends”. Somewhere they mentioned latency between 40ms -100ms as Bad.

    We have only one tempdb file as we are using Amazon RDS where it doesn't allow us to add new data file to the tempdb.

    Please suggest what steps we can take to reduce the latency.