Are there any performance benefits of using SQL Server 2008 over SQL Server 2005?
使用SQL Server 2008而不是SQL Server 2005是否有任何性能优势?
4 个解决方案
#1
1
Moving a single database from SQL Server 2005-2008 will not notice a difference really. However, there are new tools and options available in SQL Server 2008 that you MIGHT be able to leverage to provider better performance later on in your application.
从SQL Server 2005-2008移动单个数据库不会真正发现差异。但是,SQL Server 2008中提供了一些新工具和选项,您可以利用这些工具和选项在以后的应用程序中提供更好的性能。
One item that comes to mind is filtered indexes. Allowing to create an index on a subset of information.
想到的一个项目是过滤索引。允许在信息子集上创建索引。
#2
0
There may be new features in the engine which execute queries in different ways. This includes changes to the optimiser.
引擎中可能有新功能以不同方式执行查询。这包括对优化器的更改。
Therefore, the only way you can POSSIBLY tell, is to gather detailed performance data from your application on MSSQL2005, and then repeat the experiment on the same (production-quality) hardware with SQL2008.
因此,您可以说的唯一方法是从MSSQL2005上的应用程序中收集详细的性能数据,然后使用SQL2008在相同(生产质量)的硬件上重复实验。
You will need to make sure your application works correctly- such a migration can't be done lightly as any change could introduce bugs.
您需要确保您的应用程序正常工作 - 这样的迁移不能轻易完成,因为任何更改都可能引入错误。
Also, the new version of the database could have performance regressions - which you need to be very careful about.
此外,新版本的数据库可能会有性能回归 - 您需要非常小心。
So in summary:
总结如下:
- Benchmark YOUR application on SQL2005
- Benchmark it on SQL2008
- Use the same production-grade test hardware in your lab both times
- Don't run VMs (unless that's what you do in production)
- Don't change other parameters
在SQL2005上对您的应用程序进行基准测试
在SQL2008上进行基准测试
在您的实验室中使用相同的生产级测试硬件
不要运行VM(除非你在生产中这样做)
不要更改其他参数
This may not be easy if your application is big / complicated.
如果您的应用程序很大/很复杂,这可能并不容易。
#3
0
Yes. You can compress data in SQL 2008 which can have drastic impact on backup and data transfer times.
是。您可以在SQL 2008中压缩数据,这会对备份和数据传输时间产生巨大影响。
#4
0
Actually SQL2008 has built-in compression that you can enable out of the box which could definately improve performance, but it may depend on what is being returned. I would try this option and benchmark to see if you feel its a worthy change.
实际上SQL2008具有内置压缩功能,您可以开箱即用,可以明确提高性能,但这可能取决于返回的内容。我会尝试这个选项和基准测试,看看你是否觉得它是一个值得改变的。
#1
1
Moving a single database from SQL Server 2005-2008 will not notice a difference really. However, there are new tools and options available in SQL Server 2008 that you MIGHT be able to leverage to provider better performance later on in your application.
从SQL Server 2005-2008移动单个数据库不会真正发现差异。但是,SQL Server 2008中提供了一些新工具和选项,您可以利用这些工具和选项在以后的应用程序中提供更好的性能。
One item that comes to mind is filtered indexes. Allowing to create an index on a subset of information.
想到的一个项目是过滤索引。允许在信息子集上创建索引。
#2
0
There may be new features in the engine which execute queries in different ways. This includes changes to the optimiser.
引擎中可能有新功能以不同方式执行查询。这包括对优化器的更改。
Therefore, the only way you can POSSIBLY tell, is to gather detailed performance data from your application on MSSQL2005, and then repeat the experiment on the same (production-quality) hardware with SQL2008.
因此,您可以说的唯一方法是从MSSQL2005上的应用程序中收集详细的性能数据,然后使用SQL2008在相同(生产质量)的硬件上重复实验。
You will need to make sure your application works correctly- such a migration can't be done lightly as any change could introduce bugs.
您需要确保您的应用程序正常工作 - 这样的迁移不能轻易完成,因为任何更改都可能引入错误。
Also, the new version of the database could have performance regressions - which you need to be very careful about.
此外,新版本的数据库可能会有性能回归 - 您需要非常小心。
So in summary:
总结如下:
- Benchmark YOUR application on SQL2005
- Benchmark it on SQL2008
- Use the same production-grade test hardware in your lab both times
- Don't run VMs (unless that's what you do in production)
- Don't change other parameters
在SQL2005上对您的应用程序进行基准测试
在SQL2008上进行基准测试
在您的实验室中使用相同的生产级测试硬件
不要运行VM(除非你在生产中这样做)
不要更改其他参数
This may not be easy if your application is big / complicated.
如果您的应用程序很大/很复杂,这可能并不容易。
#3
0
Yes. You can compress data in SQL 2008 which can have drastic impact on backup and data transfer times.
是。您可以在SQL 2008中压缩数据,这会对备份和数据传输时间产生巨大影响。
#4
0
Actually SQL2008 has built-in compression that you can enable out of the box which could definately improve performance, but it may depend on what is being returned. I would try this option and benchmark to see if you feel its a worthy change.
实际上SQL2008具有内置压缩功能,您可以开箱即用,可以明确提高性能,但这可能取决于返回的内容。我会尝试这个选项和基准测试,看看你是否觉得它是一个值得改变的。