The fastest way to rebuild indexes

We have over 5 Tb database. There are some indexes more then 15 Gb in size.

The total rebuild of all indexes which are fragmented more then 30% takes about 1 day to perform.

It takes about 7 minutes to rebuild one index of 26 Gb in size. Is this ok?

We tried to make several jobs to go in parallel, but it makes no help.

What is the fastest possible way to rebuild indexes?

June 17th, 2015 9:50am

Hi zhichkin,

The fastest possible way to rebuild indexes is to rebuild the indexes in OFFLINE mode because OFFLINE index rebuilds do require less resources and take less time to complete than ONLINE index rebuilds.

And if you are using SQL Server enterprise edition, increase the "maximum degree of parallelism" (MAXDOP) when rebuilding indexes, which will speed up SQL Server off-line index rebuilds.

For more details about rebuilding indexes, please review the following blogs.
Rebuilding SQL Server indexes using the ONLINE option
Reduce Time for SQL Server Index Rebuilds and Update Statistics


Thanks,
Lydia

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 2:12am

Adding to Lydia's response Make sure you use Ola hallengren for index rebuild its tested and used industry wide.

June 18th, 2015 3:02am

Thank you, Lydia, very much! The links given in your answer was very usefull.
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 3:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics