SQL Server Performance

Optimization and Integrity jobs

Discussion in 'General DBA Questions' started by Krasavitsa, Jul 14, 2009.

  1. Krasavitsa New Member

    Can I run Optimization on Satarday and Integrity on Sunday and Wenesday? Also,can someone provide me a good documentation what they do?Thank you
  2. Luis Martin Moderator

    Yes you can.
    Check BOL for documentation.
  3. Krasavitsa New Member

    I can't find a good documentation what optimization job do and integrity job do, do you have a link to it?
  4. Luis Martin Moderator

    From BOL
    The Check Database Integrity task checks the allocation and structural integrity of all the objects in the specified database. The task can check a single database or multiple databases, and you can choose whether to also check the database indexes.
    The Check Database Integrity task encapsulates the DBCC CHECKDB statement. For more information, see DBCC CHECKDB (Transact-SQL).

Share This Page