MS SQL Server on Amazon EC2 - 20Gb, 75% rewrite every night
- by Ivan Belov
Client asked if we can host our application for them on Amazon Cloud. The app has database running on MS SQL Server which is approximately 20 Gb in size.
We need to update the database almost every night and approximately 75% of all data is overwritten each time.
Any idea whether Amazon EC2 can reliably handle a load like that?