Does anyone have performance stories to share about running SQL Server 2008 on Amazon EC2 instances? We are performing some tests, and not unexpectedly see some disk IO performance issues. Specifically, avg disk queues backing up as much as 6,500 deep. where on similar physical hardware, the queues never go above 20.

The test instance only uses 2 disk volumes, 1 for OS, 1 for data, with separate data and index filespaces. Would additional EBS disk volumes reduce some of the IO bottlenecks, or does EBS eliminate the benefit we would see with separate physical volumes for data, index, and logs?

  • It also depends on the instance type, the smaller instances are allocated lower bandwidth I/O channels. – devstuff Jul 8 '10 at 9:50

Using RAID-0 with several EBS volumes will increase performance, but in the end disk I/O is shared on AWS, which is why you will see better speeds on a dedicated machine.

  • I've the same requirement as that of OP here, but for PostgreSQL database. Using RAID-0 with several EBS volumes will increase performance -- can you share on how to setup one? – Gnanam Dec 13 '10 at 14:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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