Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
1 Solution
 
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
 
arnoldCommented:
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
 
anushahannaAuthor Commented:
thanks arnold!..
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now