Sql Server 2005效率节省？
与 Sql Server 2000 相比，使用 Sql Server 2005 是否能显着提高效率？
或者它只是有更多的服务等
有没有人看到他们的系统在升级后运行得更快？
Are there good efficiency savings using Sql Server 2005 over Sql Server 2000?
Or does it just have more services etc
Has anyone seen their system work any quicker after making the upgrade?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
到 2005 年，事情绝对会运行得更快。对查询优化器进行了一些改进。 现在您可以创建覆盖索引，以便包含的列仅存在于叶级别，而不必进行排序。 仅此一点就已经是一个巨大的改进并且足以成为升级的理由。
Things will absolutely run faster with 2005. There were several improvements made to the query optimizer. And now you can create covering indexes so that the included columns only exist at the leaf level and don't have to get sorted. That alone is an enormous improvement and reason enough to upgrade.
SQL 2005 在缓存方面做得更好。 您过去必须定期轮询 SQL 2000 以检查整个表的更新。 现在，您可以在发生变化时订阅通知。 它也适用于查询、表和一些其他元素。
SQL 2005 does a better job of working with caching. You used to have to poll SQL 2000 periodically to check for updates to a whole table. Now you can subscribe to a notification when something changes. It also works for queries, tables, and a few other elements.
出于其他人列出的所有原因，我会说“是”，但即使您的 SQL 技能不是那么强并且您的查询不是那么好，它们在 2005 年可能会运行得更快。我们从 2000 年转移到 2005 年，我们有一些复杂的查询我们在 2000 年无法得到适当的优化。当我们进入 2005 年时，它吞噬了查询！ 显然，优化器可以立即做出更好的决策。
我强烈建议您转向 2005 年，除非您对 2000 年没有任何问题。
I would say yes for all of the reasons listed by others, but even if your SQL skills are not that strong and your queries are not that great they will probably run faster on 2005. We moved from 2000 to 2005 and we had some complex queries that we could not get properly optimized in 2000. When we moved to 2005 it ate the queries up! Clearly the optimizer was making much better decisions out of the box.
I would strongly recommend moving to 2005 unless you have no issues with 2000.
2005 提供了 MVCC（本质上是行级版本控制），因此作为开发人员，可以提高效率：减少需要担心的锁定。
2005 provides MVCC - row level versioning essentially - so as a developer there are some efficiencies: less locking to worry about.
我没有从 2000 年迁移到 2005 年的系统 - 我要么从其中一个开始，要么从另一个开始 - 所以我没有自己的比较。 但您很有可能会看到性能差异； 如果没有利用快照隔离等一些新功能，那么至少可以通过 SQL2005 的许可模型允许您无需额外许可成本即可使用多核，并且 SQL2005 改进了内存管理。
I haven't migrated a system from 2000 to 2005 - I've either started with one or the other - so I don't have a comparison of my own. But there is a reasonable chance you will see a perf difference; if not by taking advantage of some of the new features like snapshot isolation, then at least by virtue of the fact that SQL2005's licensing model allows you to go multi-core at no additional licensing cost, and by the fact that SQL2005 has improved memory management.
周围的工具（例如 Analysis Services）已被大幅重写，可以根据您的要求为您带来各种好处。 然而，从 2000 年到 2005 年，我没有看到核心数据库引擎有很多真正根本性的变化。
有一些改进可能会让您在某些情况下获得更好的性能。 SQL2005 比 SQL2000 更好地支持 64 位体系结构和更好的表分区（您可以对表进行分区，而不是创建分区视图）。 64 位支持最有可能在大型系统上为您带来性能优势，因为它允许您设置更大的缓存。
除了这些功能之外，我不认为真的有很大的区别。 可能会有一些小的性能调整。
从 SQL2000 迁移到 SQL2005 的主要原因是 SQL2000 不再受支持。 如果您有一个在 SQL2000 上运行的应用程序，则没有太多令人信服的理由切换到 2005，而 Microsoft 仍然支持 2000。
数据仓库系统通过迁移到 SQL2005 将会获得不少好处。 SSIS、SSAS2005 和 SSRS2005 比它们的 SQL2000 对应产品要好得多。
The surrounding tools such as Analysis Services were substantially rewritten and can get you a variety of wins depending on your requirements. However I don't see a lot of really fundamental changes from 2000 to 2005 in the core database engine.
There are some improvements that may get you better performance in certain situations. SQL2005 has much better support for 64-bit architectures and better table partitioning than SQL2000 (you can partition a table as opposed to making partitioned views). 64-bit support is the most likely to give you a performance win on a large system as it allows you to set up much larger caches.
Apart from those features I don't believe that there is really a large difference. There are probably minor performance tweaks.
The main reason to move from SQL2000 to SQL2005 will be when SQL2000 goes out of support. If you have a running application on SQL2000 there are not a lot of compelling reasons to switch to 2005 while 2000 is still supported by Microsoft.
Data Warehouse systems will get quite a few wins from moving to SQL2005. SSIS, SSAS2005 and SSRS2005 are much better than their SQL2000 counterparts.