[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1262
  • Last Modified:

Tracking the progress of a Index Rebuild

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.
0
athelu
Asked:
athelu
1 Solution
 
patriktCommented:
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.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now