August 3, 2009 at 8:14 am
I have a database where I need to deploy a reindexing strategy , i.e. a way to reorganize them without downtime. There is a mirror setup on thos db which means I cannot change the recovery. Does anyone have any suggestions on what my approach might be with respect to scheduling maintanance on indexes since these get heavily fragged every month? something like a round robin of a few tables each time.
The index size is way bigger than the table size. I tested Reorganizing a clustered index and it seems to generate about 1.3 GB of log for a table size of 540 MB. I am wondering if Reorganizing a clustered index auto reorganizes the non clustered indexes on this table as well.
Any suggestions would be appreciated
Regards
Akhil
August 3, 2009 at 9:50 am
Michelle Ufford (@sqlfool on Twitter) has an excellent index maintenance script[/url] on her blog[/url]. I'd recommend looking at it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 5, 2009 at 12:23 am
Thanks for your reply. that helps regarding the strategy, but I am still unable to ascertain whether reorganizing a clustered index also reorganizes the non clustered indexes on the same table.
I am aware that this is true in case of "Rebuilding" indexes.
August 5, 2009 at 6:53 am
No reorganizing/rebuilding a clustered index does not reorganize or rebuild the non-clustered.
http://technet.microsoft.com/en-us/library/ms189858(SQL.90).aspx
http://www.ford-it.com/sqlagentman/?p=206
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply