What jobs to run to make sure the SQL server and databases are at their best?

• Tejwant Kaur-333539

  SSCommitted

  Points: 1647

  More actions

  October 10, 2006 at 5:52 pm

  #170609

  Hi All,

  I'm quite new to the DBA kind of activites and need to start running maintenance jobs on the databases. I need to know which jobs should be run? Would I need exclusive access to run these jobs? Also, what should be their frequency - monthly, fortnightly, weekly?

  I am running DBCC CHECKDB everynight on the databases.

  Someone told me that the database tables are quite fragmented, and need defragging. Should I run DBCC Defrag for that, and would I need exculsive access? What other jobs should i run?

  Your help is highly appreciated.

  Thanks,

  TK

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  October 11, 2006 at 8:21 am

  #665227

  Hello,

  This is quite a broad question and I think this directly related to your environment.

  Obviously backups should be run but this is dependant on your recovery strategy as far as frequency is concerned.

  Reindexing is a common process to run overnight if you find performance is suffering or you are updating large tables over night.

  Do you have replication running?

  Are you running any overnight calculations?

  Are you dealing with any data feed sources?

  These sort of things and many others can possibly have jobs that need to run.

  How big is your environment?

  HTH

  Regards...Graeme