亚马逊EC2 SQL性能 [英] Amazon EC2 Sql Performance

问题描述

我使用的是亚马逊的EC2与Windows实例和放大器考虑; SQL。我已经看到了<一个href="http://www.brentozar.com/archive/2008/11/bad-storage-performance-on-amazon-ec2-windows-servers/">some批评这里的SQL实例PERF的。我想知道如果任何SOers已经和第一手经验，并在性能上可以发表评论。

I'm considering using Amazon's EC2 with a windows instance & SQL. I've seen some criticism of the perf of the SQL instances here. I'm wondering if any SOers have and first hand experience and can comment on the performance.

推荐答案

我刚刚解雇了32位服务器2003 M1小实例与SQL 2005前preSS和有一个快速的发挥。只是使用提供的机磁盘，而不是一个附加的体积。阅读文章链接到您的文章后，我期待的表现是可怕的。这是不是很大，但也不坏。

I've just fired up a 32bit Server 2003 m1 small instance with SQL 2005 Express on and had a quick play. Was just using the supplied machine disk, not an attached volume. After reading the article linked to in your post I was expecting performance to be horrific. It wasn't great, but wasn't bad either.

我的测试是相当简单。创建表与标识列，几个文本（VARCHAR）colomns和几个整数外键列有关系，一些基本的查询。

My 'tests' were rather simple. Created a table with an identity column, a few text (varchar) colomns and a few more integer foreign key columns with relationships to some basic lookups.

花了大约一分钟，以插入100万条记录，以及有关第二个使用像'％强制表扫描，以更新数据20万行模块。

It took about a minute to insert 1 million records, and about a second to make updates to 200,000 row blocks of data using Like '% to force a table scan.

这并没有告诉我们什么表现会像重负载下任何东西。

This doesn't tell us anything about what performance will be like under heavy load.

结论：不是很大，但可能会更加糟糕 - 尤其是考虑到该磁盘存储在AWS的方式。我不认为这真的是一个大的SQL Server安装的地方，大量的小装置可能是更insteresting前景。 我也有兴趣看看是什么样的性能与DB spead了许多小挂接的卷。

Conclusion: Not great, but could be worse - especially given the manner in which 'disks' are stored on aws. I don't think this is really the place for a big SQL Server installation, lots of small installations might be a more insteresting prospect. I'd also be interested to see what performance was like with the db spead over lots of small attached volumes.

我希望使用EC2为即将开展的项目，将做一些更全面的测试，在未来几个星期。 - 我会后的结果，因为他们是可用的。

I'm hoping to use EC2 for an upcoming project and will be doing some more thorough testing over the next few weeks. - I'll post the results as they're available.

期待看到什么其他人的经历是..

Looking forward to seeing what other peoples experiences have been..

这篇关于亚马逊EC2 SQL性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！