Need to move 3 semi-large (millions of rows) related tables with clustered indexes to a new filegroup on the SAN. Is there a way to estimate how long dropping / recreating clustered index will take? Is there a way to monitor the percentage complete / time remaining for creating the clustered index? Need to tell management what approximate downtime to expect.

  • 1
    take the size of the table (because clustered indexes are the table) and then calculate source read speed vs target write speed. Add a fudge factor of 2x and then some more if it's going to be during a maintenance window or during business hours. – Jonathan Fite Apr 15 at 15:55
  • 1
    Also consider just adding files to the existing filegroup. Placing objects on different filegroups often not a good idea. – David Browne - Microsoft Apr 15 at 17:29
  • why do you say that, @DavidBrowne-Microsoft? What troubles could come from placing objects on different filegroups? – Ronaldo Apr 15 at 18:05
  • 1
    Uneven IO utilization is the biggest downside of manually allocating object to filegroups. – David Browne - Microsoft Apr 15 at 18:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.