RE index rebuilds
Walter Vaughan
wvaughan at steelerubber.com
Wed Jun 29 10:51:21 PDT 2011
Richard Kreiss wrote:
>One of my clients has a procedure the rebuilds auto indexes at night.
>
>The procedure has gone from 45 minutes to about 2 1/2 hours.
>
>
Don't your clients run windows?
>One file has 6 auto index ranging in size from 11MB to 76Mb.
>
>
My experience on *bsd is that would take 45 seconds to 2-1/2 minutes :)
.. the real problem is disk. Here's something that I have ran into recently
with similar problem and MS-SQL. NTbackup was not completing
and it was not obvious what the culprit was. It was jamming up disk IO but
not affecting CPU.
Here's what you want to google... "Average Disk Queue length"
Become an expert on that... then you will know exactly what
is going on and what is *really* making it take so long.
Honestly MS does have enough tools to debug this. It's just
stuff that you never worry about on the client side, so experience
for the average sysadmin is limited.
More information about the Filepro-list
mailing list