asked
Rebuild Of Indexes
I have 6 database in sql server 2008r2 which are 250gb + each databases has aproxmately 1000 tables out of which 400 tablels fragmentations is more than 60% .i have defragmented all the Index manually now the owner wants to create a mentance plan for rebuilding Indexes . since the size of databases are to large so How much time each plan will take for individual databases.
You have some answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
Free alternatives to @Tom Staab's suggestion: * Michelle Ufford (@SQLFool) has a very fine index defrag script available -
http://sqlfool.com/2011/06/index-defrag-script-v4-1/ * Those clever Midnight DBAs have come up with their own solution -
http://www.midnightsql.com/minion/minion-reindex/ * For those of you stuck on SQL 2000 (no longer me - yay!), I did a lightweight routine:
https://thelonedba.wordpress.com/2011/07/29/index-maintenance-for-sql2k/ Whichever script tool you use, please consider using the various TimeOut / TimeLimit / RunTime parameters that limit the duration of your maintenance window. There are other tools out there, for example: * Red Gate SQL Index Manager -
http://www.red-gate.com/products/dba/sql-index-manager/ - not a background admin scheduled maintenance plan in itself, but might be helpful in identifying problems at a particular time. Good luck!
20 People are following this question.
