Setting up a Windows based web application on Amazon's cloud has definitely been a learning experience. Lots of unexpected hoops to jump through, especially to get around the limitations associated with ephemeral local drives.
I was hoping to tap into the collective wisdom of those who have walked this road ahead of me and get some insight into best practices and/or tips for running SQL server on an Amazon EC2 Instance.
Amazon EC2 supports a self-managed SQL Server database. That is, it gives you full control over the setup of the infrastructure and the database environment. Running the database on Amazon EC2 is very similar to running the database on your own server.
We recommend that you choose Amazon EBS-optimized instance types for SQL Server. These offer the best throughput with attached EBS volumes in a dedicated network, which is critical for SQL Server workloads that might have heavy data access requirements.
Use quality servers with enough CPUs and RAM. A High I/O subsystem is essential for high performance. Establish a separate partition for the operating system of the server and allow for adequate space for Windows/SQL updates. Choose a high quality RAID card and enable the write cache for 100% if possible.
Storing web-directory and SQL Server files in EBS is an easy way to get around the flimsyness of local storage.
I've made a script for backing up SQL-Server to S3:
http://friism.com/ec2-sql-server-backup-strategies-and-tactics
Here are some more general thoughts on running ASP.Net websites off EC2:
http://friism.com/rent-vs-buy-or-ec2-vs-building-your-own-iron
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With