I currently have an AWS RDS SQL Server Instance in place and the app that uses it see's peek usages during certain hours of the day. (9-10 and 6-7), during these times we are seeing a huge slow down in the DB performance. Now we can obviously scale up the backing EC2 instance but this seems like a large amount of wasted resource over the timeframe.
Is there any way to have a more flexible solution? IE Like elastic beanstalk allows us to add extra 'nodes' during peak times?