SQL Server 2008 在生产环境中表现出色? [英] SQL Server 2008 express performance in production environment?

问题描述

我即将移动服务器，我正在与某人交谈，他们建议使用安装在服务器上的 sql server express 2008.我可以完全访问服务器.

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.

这个 express 引擎的工作速度(性能)是否与真正的 sql server 2008 相同?

Does this express engine work at the same speed (performance) as a true sql server 2008?

我知道限制，即每个 DB 最大 4 GB ......和最大 1 GB 内存......考虑到服务器安装了 2GB 并与 Windows 共享......我不认为这是一个问题，但很想听到一些反馈..

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..

我有大约 4 个 dbs .. 他们可能有 4 个用户同时登录，这真的没什么用...

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...

我真正想确定的是，我是否应该在服务器或 express 上安装 SQL SERVER 2008 完整版..

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.

似乎 express 使用与 FULL 版本相同的数据库引擎......

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 ...

非常感谢任何帮助

推荐答案

Express 与其他 SQL 版本(工作组、标准、企业/开发人员和数据中心)的代码相同.唯一不同的代码库是CE"版本，它基于移动 SQL CE 代码.Express 具有您已经列举的限制(DB 大小、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.

这篇关于SQL Server 2008 在生产环境中表现出色?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！