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?