can anyone suggest Jobs that will improve database availablity and performance in sql server 2008?
A:
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! :-)
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
Kragen
2009-07-07 10:43:06