question

srivastavanitesh16 avatar image
srivastavanitesh16 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.
sql-server-2008sql
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Tom Staab avatar image
Tom Staab answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
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!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.