-
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!
-
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|