Results 1 to 9 of 9

Thread: Index Maintenance Plan Help

  1. #1
    Join Date
    Jan 2009
    Posts
    22

    Index Maintenance Plan Help

    I have a maintenance plan that Reorganizes, Shrinks, and Stats for all of my databases. Why is it that it only updates Stats on certain tables and not all? Am I doing something wrong?

    I am doing the following in order:

    1 - Reorganize Index Task: All Tables and Views
    2 - Shrink Database Task: Limit 50 MB, Free space 3%
    3 - Update Stats Task: All Tables and Views

    Any recommendations to do this better will be great!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    First of all, don't shrink db. It double permformance hit. For update stats, sql will not touch table if it has no index nor stats created.

  3. #3
    Join Date
    Jan 2009
    Posts
    22
    Ok so I will take out the shrink of db. So by doing the reorganizing and updating I am good for best performance of the database?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Not best but better. How often do you rebuild index by the way?

  5. #5
    Join Date
    Jan 2009
    Posts
    22
    I have them scheduled once a week...Sunday to be specific

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Update stats/reorg index weekly or rebuild index weekly?

  7. #7
    Join Date
    Jan 2009
    Posts
    22
    both are done weekly - they are in one maint plan

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    Not good, you don't need update stats/reorg index after rebuild index. Can set schedule like rebuild index weekly and do update stats/reorg index on other days except the reindex day.

  9. #9
    Join Date
    Jan 2009
    Posts
    22
    Ok Great! thank you - I will update my maint plans...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •