SQL Server Performance

URGENT: how do you check the progress of rebuild indexes for a database?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Jul 10, 2013.

  1. Trev256b Member

    I have tried the following script but it always displays 0% as percent complete. Does anyone know how to display the actual percent completed? I am rebuilding all the indexes for a single database. I need to establish how long this will take as it could take a long time and it is running now!

    SELECT

    percent_complete, start_time,status, command, estimated_completion_time, cpu_time,
    total_elapsed_time

    FROM
    sys.
    dm_exec_requests
  2. FrankKalis Moderator

  3. Trev256b Member

    Thanks Frank. Unfortunately I tried this and it didn't return a useful result. Please let me know if SQL server DBA engine develops a way to estimate progress more reliably in the future. :)

Share This Page