用于在 Amazon EC2 微型实例上进行生产的 SQL Server Express 2008 R2
感谢您花时间阅读我的问题。在讨论真正的问题之前先介绍一些背景知识。我们正在构建一个应用程序，但我们不知道在启动项目的第一天甚至启动后几个月我们会获得多少数量。
我们使用 SQL Server Express 2008 R2 进行开发，并且最好在 Amazon EC2 上使用 SQL Server 08 Standard 进行生产。然而，正如您所知，带有 SQL Server 08 Standard 的 Amazon EC2 很昂贵，至少对我们来说是这样。
我很难决定是否应该选择 SQL Server Express 08 用于生产用途，并在需要时进行扩展，还是立即开始使用 Sql Server 2008 Standard？
我在互联网上搜索了一些使用 SQL Server 2008 Express 进行生产的人的经验，发现一些关于它的讨论很有帮助。
生产环境中的 SQL Server 2008 Express 性能如何？
https://serverfault.com/questions/60670/sql-server-express-for-product-数据库
根据我的研究，我知道 Sql Server Express 可以处理 1 GB 的 RAM、1 个 CPU（可以有多个核心）和每个数据库 10 GB 的限制。我还阅读了这篇文章，其中有人提到缺乏 SQL Server 代理和分析等，您可以使用开发人员版本并远程登录来衡量性能等。
我计划在 Amazon Micro 实例上运行 Sql Server Express 08（此实例将是仅适用于数据库）。
“微型实例 613 MB 内存，最多 2 个 ECU（用于短周期突发），仅 EBS 存储，32 位或 64 位平台”
所以我不确定 Express 可以使用多少内存，因为我相信很多将被操作系统占用。
我真正的问题是，是否有人使用 SQL Server Express 08 通过上述设置或类似的方式进行生产？ Express 能够处理多少并发连接？您在管理生产快递方面遇到了哪些挑战？
如果您可以抛出诸如“500 个用户正在使用您的应用程序，并且在您的应用程序的每个页面中都会调用多个 SP 并且 Express 能够处理它”之类的数字，那么将会非常有帮助。
我想使用 Express 的原因是先节省一些钱，然后再进行扩展。
另一种选择是，如果我必须使用标准版本，我可以进入 Microsoft Bizspark 并获得标准版本许可证并安装在我的 EC2 实例中，以减少前期成本。我想节省一点，但同时我也不希望我的应用程序用户因缺乏资源而遭受损失。
我非常感谢您阅读我的帖子，并期待听到您的经验或建议。
问候， BRBH
Thank you for taking the time to read my question. A little background before I get to the real question. We are building an application and we do not know how much volume we are going to get the first day we launch our project or even few months after we launch.
We are using SQL Server Express 2008 R2 for development purpose and would optimally use SQL Server 08 Standard on Amazon EC2 for production. However, as you know Amazon EC2 with SQL Server 08 Standard is expensive, at lest for us.
I'm having hard time trying to decide should I pick SQL Server Express 08 for my production use and later grow if there is need or do I start right away with Sql Server 2008 Standard?
I've scoured the internet to read some of the experiences from people who have used SQL Server 2008 Express for production and I've found few discussions about it which were helpful.
SQL Server 2008 express performance in production environment?
https://serverfault.com/questions/60670/sql-server-express-for-production-databases
From my research, I know Sql server express can handle 1 GB of Ram, 1 CPU (can have multiple core) and 10 GB limit per database. I also read the post where someone mentioned the lack of SQL server agent and profiling etc and you can use Developer edition and remotely login to gauge performance etc.
I'm planning to run Sql Server Express 08 on Amazon Micro Instance (this instance would be for database only).
"Micro Instance 613 MB of memory, up to 2 ECUs (for short periodic bursts), EBS storage only, 32-bit or 64-bit platform"
So I'm not sure how much memory will be available for Express as I believe much will be taken by OS.
My real question is, has someone used SQL server express 08 for production use with the above setup or similar? How many concurrent connection was Express able to handle? What challenges did you come across in regards to administering express for production?
If you can toss out numbers like "500 users were using your app and in every page of your app would call multiple SP and express was able to handle it" etc would be very helpful.
The reason I want to use Express is save some money up front and scale at a later time.
Another option is I can get into Microsoft Bizspark and get Standard version license and install in my EC2 instance to reduce my upfront cost, if I have to go with Standard Version. I want to save a bit but at the same time I don't want my app users to suffer due to lack of resources.
I greatly appreciate you reading my post and I look forward to hearing your experience or suggestion.
Regards,
BRBH
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SQL Server Express 的并发连接数同样=32767。您可以在此处查看对象规范： http://msdn.microsoft.com/en -us/library/ms143432.aspx 。
回答你的第二个问题——很多人使用 Express 进行生产。您可以根据您的项目规模在快速和标准之间进行选择。
Express 可以同时处理 500 个用户。但他们会做什么呢？如果他们要搜索文本中的片段，性能会非常慢。但如果它应该是简单的 CRUD 语句，那么就不会有问题。
一件重要的事情 - 从 Express 开始，您始终可以升级到标准版或企业版。
SQL Server Express has the same concurrent connection quantity =32767. You can see object specification here: http://msdn.microsoft.com/en-us/library/ms143432.aspx .
Answer on your second question - a lot of people use Express for production. You can choose between Express and standard depending from your project size.
It is possible to handle 500 users at the same time on Express. But what they will do? If they will search a fragment in a text, performance will be very slow. But if it should be simple CRUD statements so no problems should be there.
And one important thing - starting from Express, you always can upgrade to Standard or Enterprise version.