Tracking the progress of a Index Rebuild

Posted on 2007-07-23
Last Modified: 2008-09-08
I need away to track the progress of a Index Rebuild.  I am working with a VLDB and need a way to tell the progress of a index rebuild.  It would be good to know the estimated time to complete or something.  My maintenance window is 2 hours each month and I need a good way to plan for index maintenance.   Suggestion are welcome.
Question by:athelu
    1 Comment
    LVL 12

    Accepted Solution

    No chance to do this. Unfortunately there is no generic way how to find degree of complexity for rebuild.
    Index is B-tree structure phisicaly stored on 8k pages. As it is build by table scan from first row found you couldn't guess complexity of time untill the table end. :(

    But for your special tables which you know about it can be possible to develop some proprietary formula.
    Try experiment and find:
    Time=fragmentation * (k * Rows+ l * (size/8k))
    Where fragmentation is function of time between DB defragment.

    That is all I can give you.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now