January 4, 2010 at 10:50 am
In what order should I run in wizard db maintance:
Reorginize index
rebuild index
check db integrity
Shrink db
Thank you
January 4, 2010 at 12:56 pm
Krasavita (1/4/2010)
In what order should I run in wizard db maintance:Reorginize index
rebuild index
check db integrity
Shrink db
Thank you
Reorg and Rebuild should be a dynamic run - both do not need to be run for every index - thus there wouldn't be a specific order for them.
Shrink DB is not one that you should run on a regular scheduled basis.
DB Integrity is the only one that should be run regularly and can be scheduled as is (amongst the options you listed and based on the prior statements). And I would run that prior to the index maintenance task.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 4, 2010 at 1:30 pm
So, In 2000 we have option for optimization and integrity and in 2005 check db integrity replaces integrity job, what about optimization?Thank you
January 4, 2010 at 1:41 pm
The optimization would include your index maintenance, and statistics maintenance. However, you should not try to do a rebuild and re-org of indexes of all indexes - they are not truly separate tasks. Instead, you should be distinguishing which indexes qualify for a reindex and which indexes qualify for a re-org and perform that as part of a single maintenance plan.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply