July 23, 2010 at 2:00 pm
Is this correct order to do my weekly my maintenance plan wizard for all my dev databases
1.CheckDatabaseIntegrity
2.Update Statistics
3.Reorginize Index
4.Rebulding Index
5.Cleanup History
6.Maintance Cleanup Task
Thank you
July 23, 2010 at 2:19 pm
Krasavita (7/23/2010)
Is this correct order to do my weekly my maintenance plan wizard for all my dev databases1.CheckDatabaseIntegrity
2.Update Statistics
3.Reorginize Index
4.Rebulding Index
5.Cleanup History
6.Maintance Cleanup Task
Thank you
Ran "2.Update Statistics" after 3 & 4 (Reorganize / Rebuild index).
Just curious: What history will be cleaned up at step 5?
July 23, 2010 at 2:53 pm
Does sp_recompile come into play her at all? Or does Updating Stats do that?
July 23, 2010 at 3:20 pm
You don't need to reorganize and rebuild indexes in one maintenance plan (remove reorganize).
If you perform rebuild then you don't need to update statistics because rebuild also update statistics.
You don't need to use sp_Recompile after maintenance plan.
July 23, 2010 at 4:18 pm
kladibeeto (7/23/2010)
If you perform rebuild then you don't need to update statistics because rebuild also update statistics.
Rebuild only updates index statistics, not column statistics. The update stats is still necessary, but it can be modified from default and only column statistics selected.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply