Printable View
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!
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.
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?
Not best but better. How often do you rebuild index by the way?
I have them scheduled once a week...Sunday to be specific
Update stats/reorg index weekly or rebuild index weekly?
both are done weekly - they are in one maint plan
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.
Ok Great! thank you - I will update my maint plans...