SQL Server Performance

Update Statistics Vs DBCC REINDEX

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Balasundaram, May 14, 2007.

  1. Balasundaram New Member

    Hi,

    I would like to schedule some maintenance tasks on my db server. I have confusion in this.

    What is the difference and purpose between update statistics and dbcc reindex?

    If i need to schedule both, which one i need to run first and on what frequency needs to be done.

    Thanks,
    Bala
  2. satya Moderator

    DBCC DBREINDEX must be scheduled first and only include those tables that are modified frequently here and not all ofthem if your system needs 24/7 availablity. In addition to this intermittent UPDATE STATISTICS execution will also help to retain the performance.

    You should leave the AUTO_UPDATE stats option ON the database is required most performance.

    The difference between them is to review BOL in addition to:
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
    http://sqlserver-qa.net/blogs/tools...r-2005-index-optimization-best-practices.aspx

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. Balasundaram New Member

    Thanks Satya. It's really useful

Share This Page