SQL Server 2005标准版和企业版之间的性能差异 [英] Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
问题描述
亲爱的所有人，
我们有一个数据库，其中包含许多具有数百万美元b $ b b记录的表格。当我们附加数据库与MS SQL Server 2005 Standard
Edition Server并运行一些查询（有连接，过滤器等）然后
他们需要很长时间才能执行当我们在企业版上执行相同的查询
时，它们的运行速度比标准的
版快10倍。
我们的数据库确实如此不使用Enterprise
Edition中存在且在Standard Edition中不存在的任何功能。我们想知道什么是
标准版和企业版之间的差异为
性能。当标准
版具有所需的所有功能时，我们为什么要选择企业版。
我们目前正在使用SQL Server 2005 Standard的评估版
和企业版。
谢谢和问候，
Nishant Saini
http://www.simplyjava.com
Nishant Saini（ni*********** @ gmail.com）写道：
我们有一个包含许多表的数据库拥有数百万美元的b $ b记录。当我们附加数据库与MS SQL Server 2005 Standard
Edition Server并运行一些查询（有连接，过滤器等）然后
他们需要很长时间才能执行当我们在企业版上执行相同的查询
时，它们的运行速度比标准的
版快10倍。
我们的数据库确实如此不使用Enterprise
Edition中存在且在Standard Edition中不存在的任何功能。我们想知道什么是
标准版和企业版之间的差异为
性能。当标准
版具有所需的所有功能时，我们为什么要选择企业版。
在联机丛书中有一个主题。在我的头顶
我不记得任何立即，但我现在正在接受其他事情，
并且不想环顾四周。
您可以发布您正在测试的一个查询以及标准版和企业版的
查询计划吗？
我假设您在同一硬件上运行两个版本？
-
Erland Sommarskog，SQL Server MVP， es **** @ sommarskog.se
SQL Server 2005联机丛书 http://www.microsoft.com /technet/pro...ads/books.mspx
SQL Server 2000联机丛书
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nishant Saini写道：
亲爱的所有人，
我们有一个数据库包含许多表，其中有数百万美元的b $ b记录。当我们附加数据库与MS SQL Server 2005 Standard
Edition Server并运行一些查询（有连接，过滤器等）然后
他们需要很长时间才能执行当我们在企业版上执行相同的查询
时，它们的运行速度比标准的
版快10倍。
我们的数据库确实如此不使用Enterprise
Edition中存在且在Standard Edition中不存在的任何功能。我们想知道什么是
标准版和企业版之间的差异为
性能。当标准
版具有所需的所有功能时，我们为什么要选择企业版。
企业版提供了超越标准版的改进，
特别是在并行操作和缓存方面。如果你有一个
的大量数据，那么你将在这个版本中明确地看到更好的
性能。
问候，
lucm
数据库中是否有任何索引视图？来自在线书籍
（BOL）：
可以在任何版本的SQL Server 2005中创建索引视图。在
SQL Server 2005企业版，查询优化器自动
考虑索引视图。要在所有其他
版本中使用索引视图，必须使用NOEXPAND表提示。
因此，如果有索引视图，但没有引用对于桌面提示，
使用Enterprise
版本的性能肯定会好得多。
Roy Harvey
Beacon Falls，CT
2006年12月15日03:01:20 -0800，Nishant Saini
< ni ** *********@gmail.com写道：
>亲爱的，
我们有一个包含很多的数据库有数百万条记录的表格。当我们使用MS SQL Server 2005 Standard
Edition Server附加数据库并运行一些查询（具有连接，过滤器等）时，当我们执行相同的查询时，它们需要很长时间才能执行
在企业版上，它们的运行速度比标准版本快10倍。
我们的数据库不使用Enterprise
版本中存在且在标准版中不存在的任何功能。我们想知道标准版和企业版的性能差异是什么。当标准版具有所需的所有功能时，我们为什么要选择企业版。
我们目前正在使用SQL Server 2005 Standard和企业版的评估版。
感谢和问候，
Nishant Saini
http：// www .simplyjava.com
Dear All,
We have a database which contains many tables which have millions of
records. When We attach the database with MS SQL Server 2005 Standard
Edition Server and run some queries (having joins, filters etc.) then
they take very long time to execute while when We execute same queries
on Enterprise Edition then they run 10 times faster than on standard
edition.
Our database does not use any features which are present in Enterprise
Edition and not present in Standard Edition. We want to know what are
the differences between Standard Edition and Enterprise Edition for
performance. Why should we go for Enterprise Edition when Standard
Edition has all the features required.
We are presently using evaluation versions of SQL Server 2005 Standard
and Enterprise Editions.
Thanks and regards,
Nishant Saini
http://www.simplyjava.com
Nishant Saini (ni***********@gmail.com) writes:We have a database which contains many tables which have millions of
records. When We attach the database with MS SQL Server 2005 Standard
Edition Server and run some queries (having joins, filters etc.) then
they take very long time to execute while when We execute same queries
on Enterprise Edition then they run 10 times faster than on standard
edition.
Our database does not use any features which are present in Enterprise
Edition and not present in Standard Edition. We want to know what are
the differences between Standard Edition and Enterprise Edition for
performance. Why should we go for Enterprise Edition when Standard
Edition has all the features required.There is a topic that covers this in Books Online. On the top of my head
I don''t recall anything immediate, but I''m off to other things right now,
and don''t want to look around.
Could you post one of your queries you''ve been testing with and the
query plan on Standard and Enterprise?
I presume that you are running the two editions on the same hardware?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nishant Saini wrote:Dear All,
We have a database which contains many tables which have millions of
records. When We attach the database with MS SQL Server 2005 Standard
Edition Server and run some queries (having joins, filters etc.) then
they take very long time to execute while when We execute same queries
on Enterprise Edition then they run 10 times faster than on standard
edition.
Our database does not use any features which are present in Enterprise
Edition and not present in Standard Edition. We want to know what are
the differences between Standard Edition and Enterprise Edition for
performance. Why should we go for Enterprise Edition when Standard
Edition has all the features required.
The Enterprise Edition offers improvements over the Standard Edition,
especially on parallel operations and caching. If you have a
significant amount of data you will defnitely notice a better
performance with this edition.
Regards,
lucm
Are there any indexed views in the database? From the Books On Line
(BOL):
"Indexed views can be created in any edition of SQL Server 2005. In
SQL Server 2005 Enterprise Edition, the query optimizer automatically
considers the indexed view. To use an indexed view in all other
editions, the NOEXPAND table hint must be used."
So if there were indexed views, but no references to the table hint,
performance could certainly be far better using the Enterprise
edition.
Roy Harvey
Beacon Falls, CT
On 15 Dec 2006 03:01:20 -0800, "Nishant Saini"
<ni***********@gmail.comwrote:
>Dear All,
We have a database which contains many tables which have millions of
records. When We attach the database with MS SQL Server 2005 Standard
Edition Server and run some queries (having joins, filters etc.) then
they take very long time to execute while when We execute same queries
on Enterprise Edition then they run 10 times faster than on standard
edition.
Our database does not use any features which are present in Enterprise
Edition and not present in Standard Edition. We want to know what are
the differences between Standard Edition and Enterprise Edition for
performance. Why should we go for Enterprise Edition when Standard
Edition has all the features required.
We are presently using evaluation versions of SQL Server 2005 Standard
and Enterprise Editions.
Thanks and regards,
Nishant Saini
http://www.simplyjava.com
这篇关于SQL Server 2005标准版和企业版之间的性能差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
