I'm looking into running a single instance web application on SQL Server 2008. What are the specific advantages that the Enterprise version has over the Standard version in terms of speed. I'm not looking at the management and reporting side of things, which I understand Enterprise is much better at, but just at raw speed point of view. Based on the information found here, I've only been able to find a few differences.
我正在考虑在SQL Server 2008上运行单实例Web应用程序。企业版在速度方面比标准版具有哪些特定优势。我不是在考虑管理和报告方面的事情,我理解企业要好得多,但只是从原始速度的角度来看。根据此处的信息,我只能找到一些差异。
-
Parallel index operations - Only matters when you're creating or altering indexes. Does nothing to effect day to day speed.
并行索引操作 - 仅在创建或更改索引时才有意义。没有什么可以影响日常的速度。
-
Table and Index Partitioning - Does this really make a difference if everything is on the same disk/raid array?
表和索引分区 - 如果所有内容都位于同一磁盘/ raid阵列上,这是否真的有所不同?
-
Limited to 4 CPUs - I understand this is number of physical processor sockets, not cores, and I don't plan on needing a server ever that has more than 4 sockets. If I do, the extra cost of SQL Server Enterprise is going to be negligible. Or I could just use replication with multiple machines, which Standard edition also supports.
限制为4个CPU - 我知道这是物理处理器插槽的数量,而不是核心,我不打算需要一个有超过4个插槽的服务器。如果我这样做,SQL Server Enterprise的额外成本可以忽略不计。或者我可以使用标准版也支持的多台计算机进行复制。
Basically, what it comes down to, is Enterprise really worth the extra cash ($8487 + CAL vs. $885 + CAL), for a single instance web application?
基本上,对于单实例Web应用程序来说,企业真的值得额外的现金(8487美元+ CAL与885美元+ CAL)吗?
4 个解决方案
#1
In short - given you're worrying about performances I don't think the extra-cash is worth it unless you need extensive use of full mirroring and the other extras you mention.
简而言之 - 考虑到你对表演的担忧,我不认为额外的现金是值得的,除非你需要大量使用全镜像和你提到的其他额外内容。
Following links might be helpful:
以下链接可能会有所帮助:
SQLServer2008 Standard VS Workgroup
SQLServer2008标准VS工作组
Differences between SQLServer2008 editions - similar to the one you have there
SQLServer2008版本之间的差异 - 类似于您在那里的版本
#2
I don't believe the CAL license permits you to sit SQL Server behind a web server application. You must purchase a per-processor license to do that. Even if not, if you have more than 25 users/devices, the per-processor model is less costly (you need a CAL for each user or each device connected).
我不相信CAL许可证允许您将SQL Server放在Web服务器应用程序后面。您必须购买每处理器许可证才能执行此操作。即使没有,如果您拥有超过25个用户/设备,则每处理器型号的成本更低(您需要为每个用户或每个连接的设备提供CAL)。
Per-processor pricing for Enterprise is $24,999 and for Standard it's $5,999. You might also look into Web edition, which is $15/mo. per processor.
Enterprise的每处理器定价为24,999美元,Standard为5,999美元。您也可以查看网络版,每月15美元。每个处理器。
In answer to your question, there is some stuff like indexed views, but if you have less than 10,000 users total, your schema and query design will have way more of an impact on performance than any features not included in standard or web edition.
在回答您的问题时,有一些内容,例如索引视图,但如果您的用户总数少于10,000,那么您的架构和查询设计将比标准版或网络版中未包含的任何功能对性能产生更大的影响。
#3
Unless you're going to have huge databases, no, it's not worth it, spend the extra money on tuning the database design.
除非你要拥有庞大的数据库,否则它不值得,花费额外的资金来调整数据库设计。
#4
You really need to use the Processor licensing. There are more complicated issues regarding the licensing than you might think.
您确实需要使用处理器许可。有关许可的问题比您想象的要复杂得多。
#1
In short - given you're worrying about performances I don't think the extra-cash is worth it unless you need extensive use of full mirroring and the other extras you mention.
简而言之 - 考虑到你对表演的担忧,我不认为额外的现金是值得的,除非你需要大量使用全镜像和你提到的其他额外内容。
Following links might be helpful:
以下链接可能会有所帮助:
SQLServer2008 Standard VS Workgroup
SQLServer2008标准VS工作组
Differences between SQLServer2008 editions - similar to the one you have there
SQLServer2008版本之间的差异 - 类似于您在那里的版本
#2
I don't believe the CAL license permits you to sit SQL Server behind a web server application. You must purchase a per-processor license to do that. Even if not, if you have more than 25 users/devices, the per-processor model is less costly (you need a CAL for each user or each device connected).
我不相信CAL许可证允许您将SQL Server放在Web服务器应用程序后面。您必须购买每处理器许可证才能执行此操作。即使没有,如果您拥有超过25个用户/设备,则每处理器型号的成本更低(您需要为每个用户或每个连接的设备提供CAL)。
Per-processor pricing for Enterprise is $24,999 and for Standard it's $5,999. You might also look into Web edition, which is $15/mo. per processor.
Enterprise的每处理器定价为24,999美元,Standard为5,999美元。您也可以查看网络版,每月15美元。每个处理器。
In answer to your question, there is some stuff like indexed views, but if you have less than 10,000 users total, your schema and query design will have way more of an impact on performance than any features not included in standard or web edition.
在回答您的问题时,有一些内容,例如索引视图,但如果您的用户总数少于10,000,那么您的架构和查询设计将比标准版或网络版中未包含的任何功能对性能产生更大的影响。
#3
Unless you're going to have huge databases, no, it's not worth it, spend the extra money on tuning the database design.
除非你要拥有庞大的数据库,否则它不值得,花费额外的资金来调整数据库设计。
#4
You really need to use the Processor licensing. There are more complicated issues regarding the licensing than you might think.
您确实需要使用处理器许可。有关许可的问题比您想象的要复杂得多。