Index Rebuild taking a long time

  • 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

  • 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.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • 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