Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

Have you thought about giving Azure a look? Azure has some very interesting plans and from what you are doing it seems like it could be an even better solution than using EC2

share|improve this answer
Could be an option, but it seems there is currently 10 Gb limit on database size: – Ivan Belov Dec 4 '09 at 4:39
The limit has been raised to 50Gb. – Michael Teper Apr 1 '11 at 16:01
up vote 0 down vote accepted

We run some load tests in Amazon EC2 environment with database structure and data fill very similar to what we have in production and discovered no performance issues whatsoever.

Further, we configured mirroring replication to another instance of SQL Server running in a different location, but in the same geographic region (US East Coast). Maximum observed replication latency in our setup was about 15 minutes.

share|improve this answer

Is that possible to grab the Amazon EC2 window package only then you install you own of SQL server into that server ? i think should more control over installed express version.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.