SQL Server 2008在生产环境中表现如何？
我正要移动服务器，我正在和某人交谈，他们建议使用服务器上安装的 sql server express 2008。 我可以完全访问服务器。
这个 Express 引擎的工作速度（性能）与真正的 sql server 2008 相同吗？
我知道限制，即每个数据库最大 4 GB ...和最大 1 GB 内存...考虑到服务器安装了 2GB 并与 Windows 共享...我不认为这是一个问题，但是我很想听到一些反馈..
我有大约4个数据库..他们可能有4个用户同时登录它们，这真的没有多大用处...
我真正想要确定的是如果我应该在服务器或 Express 上安装 SQL SERVER 2008 完整版。
任何有关选择的帮助都会非常有帮助。
看来 Express 使用与完整版本相同的数据库引擎...
我不需要任何巧妙的复制、集群或类似的东西...
但我想走正确的道路...
非常感谢任何帮助
I am about to move servers and i was talking to somebody and they suggested using sql server express 2008 installed on the servers. I have full access to the server.
Does this express engine work at the same speed (performance) as a true sql server 2008?
I know about the limitations i..e max 4 GB per DB ... and max 1 GB of ram... Considering the server has 2GB installed and is shared with windows... i don't see this being a problem but would love to hear some feedback..
I have around 4 dbs .. and they have maybe 4 users logged into them at the same time, its not a great deal of use really...
What i really trying to mesure up is if i should installed SQL SERVER 2008 FULL version on the server or express..
Any help with a choice would be really helpful.
It appears express uses the same DB engine as the FULL version ...
I don't need any clever replication, clustering or things like that...
But i want to go down the right path ...
Any help really appreciated
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
Express 与其他 SQL 版本（工作组、标准、企业/开发人员和数据中心）具有相同的代码。 唯一不同的代码库是“CE”版本，它基于移动 SQL CE 代码。 Express 具有您已经列举的限制（数据库大小、RAM），并且仅使用一个调度程序，因此实际上将仅使用一个 CPU 核心。 Express 中的某些功能也受到限制，例如某些复制场景。 最大的优点是，客户可以从 Express 开始，如果他们的功能超出了其能力，他们可以更换更高版本，而无需更改任何应用程序，数据库文件可以在包括 Express 在内的所有版本之间互换。
Express is the same code as the other SQL editions (Workgroup, Standard, Enterprise/Developer and Data Center). The only different code base is the 'CE' edition, that is based on the mobile SQL CE code. Express has the restrictions you already enumerated (DB size, RAM) and also is using only one scheduler, so in effect will use only one CPU core. Also certain features are restricted in Express, like certain replication scenarios. The biggest advantage is that customers can start with Express and if they out-grow its capabilities they can swap in a higher edition without any application change, the database files are interchangeable between all editions, including Express.
它是相同的引擎，但我发现你必须一路与它作斗争，使其成为桌面环境数据库之外的任何东西，从管理到 tcpip 配置等。当然，它对数据库大小和资源使用有内置的限制。 一旦按照您想要的方式配置，它就可以正常运行。 不过，在实际的生产环境中，我发现缺少 SSIS 是一个致命的问题。
所以底线是它可用，但不是很好。 您还可以考虑工作组版，它价格合理且限制较少，但当然它比免费版更贵。
Its the same engine, but I found you have to fight it all the way in making it anything but a desktop-environment database, from management to tcpip configuration, etc. And of course, it has built in limits on database size and resource usage. Once it is configured the way you want though, it runs fine. In real production settings I find the lack of SSIS quite the killer, though.
So the bottom line is that it is usable, but not great. You might also consider the Workgroup edition, which is reasonably priced and less limited, but of course it is more expensive than free.
补充一下，SQL Express 2008 R2 可以使用多个核心（但只能使用 1 个 CPU）。
Just to add to this SQL Express 2008 R2 can use multiple cores (but only 1 CPU).
您可能会觉得 Express 没问题。 这是相同的基本引擎。 如果您想升级，这个过程应该相当轻松。
You'll probably be fine with Express. It's the same basic engine. If you ever want to upgrade, the process should be rather painless.
你应该没问题，性能应该与你的情况下的完整版本相似，因为你的数据库很小
you should be fine, performance should be similar to full version in your case since your databases are small