RE: SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Default port

Points: 1472

April 16, 2018 at 11:30 am

#1987030

Br. Kenneth Igiri - Sunday, April 15, 2018 2:27 PM
mauriciorpp - Sunday, April 15, 2018 12:04 PM
what about performance? assuming EC2 and RDS with same cpu/ram settings, which option woud be faster?
I have not simulated this so I may not be able to give an authoritative answer. However I do not expect the different to be significant.

I would assume RDS is expected to be slightly faster, because of optimizations we count that AWS will apply at the server level. For EC2 instance, the one configuring SQL server must know what he/she is doing to make optimal use of the hardware.

But if you can run some queries for benchmarking it just to make it clear to anyone doing research on this topic, it would be great. 🙂