Posted by Greg D. Moore \(Strider\) on 03/22/06 06:36

<hallpa1@yahoo.com> wrote in message
news:1142972121.442240.87670@j33g2000cwa.googlegroups.com...
> I have been testing heavily on a full copy of the production data.
> Unfortunately the test server that I was given is a much slower machine
> than the production box.
> In my test environment, doing the purge without the indexes is much
> faster than purging with the indexes in place. However, it took over
> 17 hours to rebuild the indexes afterward.

One suggestion if you can. Move the indexes to separate spindles. (but not
the clustered index).

Also, Enterprise Server can parallize a lot of index work so may be faster.

(one job I run quarterly runs 3-4x faster on one box and it appears the
deciding factor is probably Enterprise vs. Standard.)


> My estimates suggest that purging without the indexes then rebuilding
> them will take about 40 straight hours. If I try to do the purge with
> the indexes in place, it will take about 200 hours.
> If I can get a window large enough, dropping the indexes, purging, and
> rebuilding looks like the way to go. If I cannot get that window, then
> I have to do it over multiple weekends leaving the indexes in place.
> The key is that the indexes must be in place at the end of the window
> so that production processing can resume.
> Of course these numbers will be much lower on the production box, but
> since I cannot test there, I cannot guess how much lower they will be.
>

[Back to original message]