Amazon RDS provides various computing and storage options, which enables the user to decide which one suits their needs. RDS also allows you to set up several read replicas to serve read requests from both application and database users on the same RDS instance. The database and transaction logs are automatically backed up by the RDS. Thus, undoubtedly, Amazon RDS is user friendly, but it also comes with certain challenges. In your RDS DB instance, you can only create a total of 30 databases. Additionally, Amazon RDS does not enable expanding storage on a SQL Server DB instance currently.