Wednesday, January 19, 2011

MS SQL Server on Amazon EC2 - 20Gb, 75% rewrite every night

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?

  • 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

    Ivan Belov : Could be an option, but it seems there is currently 10 Gb limit on database size: http://www.microsoft.com/windowsazure/pricing/
  • 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.

    From Ivan Belov

0 comments:

Post a Comment