SQL Server Performance

Database Maintenance

Discussion in 'General DBA Questions' started by jstevenson, Dec 17, 2009.

  1. jstevenson New Member

    What should be included in an ideal mainteance script? Our weekly maintance script has the following: Defrag Index, dbcc checkdb, update statistics. Is there anything else we should include? Current DB size is approx 35GB. Any suggestions for daily maintenance as well. The only daily job we have is full backup. If it helps, heavy transactions (update/insert/delete/select) occurs last two weeks of the month.
    Any professional suggestions would be much appreciated!
  2. satya Moderator

  3. Luis Martin Moderator

    Welcome to the forums!.
    Since you have sql 2000, your actual maintenance plan is OK.
    If you have any window in working days, I suggest to include update statistics (only heavy tables). I presume your Update Statistics on week end is with "full scan"

Share This Page