daily archival jobs

like
http://www.mssqltips.com/tip.asp?tip=1749
what kind of archival do you do on a daily basis that helps in your db administration?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
arnoldConnect With a Mentor Commented:
You can use the SQL reporting service to report on index use, etc. It is better to have a baseline and monitor it as the use grows versus trying to figure out what is going on when the system stops performing.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc
Not sure whether a similar version exists for sql 2008 or whether this is sufficient.
Not sure about general all encompasing approaches.  I think since sql 2005, the server auto-tuning engine handles some "improvements" not sure what you are after.

Setting up reorganize/rebuild index based on index fragmentation and will limit the growth of the transaction log
http://blogs.msdn.com/b/joaol/archive/2008/01/28/script-to-rebuild-and-reorganize-database-indexes-sql-server-2005.aspx
0
 
arnoldCommented:
The issue is complex and depends on your data.
Using profiler,engine tuner to improve performance as well as use perfmon to baseline the server and monitor its load changes/performance impact as the amount of data grows.
0
 
anushahannaAuthor Commented:
arnold, i was thinking of general jobs that can help with any environment, regardless of specifics.profiler/perfmon come in when performance issues arise or you want to manually check on them. but if you need a daily report if there is any specific issues, or an overall picture of the environment?
0
 
anushahannaAuthor Commented:
thanks arnold!..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.