Optimization job causing timeouts

  • Main issue with your maintenance plan is Reorganize pages will Cause the indexes on the tables in the database to be dropped and re-created with the original FILLFACTOR that was specified when the indexes were created.

    During this process table will not be available for the user to access which might be cuasing the timeouts...

    If you want you can remove that Reorganize option from your MP and you can DBCC DBINDEXDEFRAG which online operation but it is not as effective as DBCC DBREINDEX...

    Read BOL for more details..

     

    MohammedU
    Microsoft SQL Server MVP

  • MANY thanks!  I have made the change, and will continue to research the DBCC options you have shown me.  Thanks again!

    -- Cory

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply