October 16, 2009 at 4:26 pm
I'm looking for ideas why an index rebuild would go from ~8 minutes to ~8 hours without significant data changes. The rebuild ocurrs daily and has been running fine for quite some time and I haven't been able to track down any issues that may have caused this.
Thanks,
Q
October 16, 2009 at 9:47 pm
If you have noticed or not, when this issue occurs, the Processor usage is near 100 % but still nothing happens.
I had this situation some time back and remember that when the Rebuild Indexes are reissued with a higher Index Fill Factor value of 90,the problem got solved.
I do not know if I did something else also, try and reply, would need to know what else can be done, if this doesn't solve.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 18, 2009 at 11:41 pm
qualon (10/16/2009)
I'm looking for ideas why an index rebuild would go from ~8 minutes to ~8 hours without significant data changes. The rebuild ocurrs daily and has been running fine for quite some time and I haven't been able to track down any issues that may have caused this.Thanks,
Q
look for blocking...I don't think that rebuild is required daily...you should first check the fragmentation and then rebuild the indexes if required.
you can also monitor the index rebuild progress from profiler.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply