can anyone suggest Jobs that will improve database availablity and performance in sql server 2008?
任何人都可以建议在SQL Server 2008中提高数据库可用性和性能的工作吗?
2 个解决方案
#1
Rebuild of indexes is a good idea if your db gets lots of action
如果你的数据库有很多动作,重建索引是一个好主意
#2
SQL Server performance is a complex topic and depending on your database and use you may find that certain regularly scheduled jobs (such as periodically rebuilding the indexes or statistics) improve performance for you, but I don't know of any scheduled jobs which will just magicly improve performance / availability in any situation - if there was it would almost certainly be there by default! :-)
SQL Server性能是一个复杂的主题,根据您的数据库和使用情况,您可能会发现某些定期调度的作业(例如定期重建索引或统计信息)可以提高性能,但我不知道任何预定的作业只会在任何情况下都可以提高性能/可用性 - 如果有的话,它几乎肯定会在默认情况下出现! :-)
Rebulding indexes
This page would be a good start for looking at rebuilding indexes:
此页面是查看重建索引的良好开端:
http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx
#1
Rebuild of indexes is a good idea if your db gets lots of action
如果你的数据库有很多动作,重建索引是一个好主意
#2
SQL Server performance is a complex topic and depending on your database and use you may find that certain regularly scheduled jobs (such as periodically rebuilding the indexes or statistics) improve performance for you, but I don't know of any scheduled jobs which will just magicly improve performance / availability in any situation - if there was it would almost certainly be there by default! :-)
SQL Server性能是一个复杂的主题,根据您的数据库和使用情况,您可能会发现某些定期调度的作业(例如定期重建索引或统计信息)可以提高性能,但我不知道任何预定的作业只会在任何情况下都可以提高性能/可用性 - 如果有的话,它几乎肯定会在默认情况下出现! :-)
Rebulding indexes
This page would be a good start for looking at rebuilding indexes:
此页面是查看重建索引的良好开端:
http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx