Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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: microsoft.com/windowsazure/pricing –  Ivan Belov Dec 4 '09 at 4:39
    
The limit has been raised to 50Gb. –  Michael Teper Apr 1 '11 at 16:01
add comment
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
add comment

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
add comment

Your Answer

 
discard

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.