Post reply

Create index progress.

  • May 28, 2010 at 10:12 pm

    #222073

    Hi Freinds,

    Suppose i had started create/alter index process. how can i know remaining time to finish?

    Do you know any query for that? Please send me...

    Thanks & Regards,

    Pravin Patel.

  • May 29, 2010 at 8:57 am

    #1174248

    See the percent_complete column on sys.dm_exec_requests

    It only works with:

  • ALTER INDEX REORGANIZE
  • AUTO_SHRINK option with ALTER DATABASE
  • BACKUP DATABASE
  • CREATE INDEX
  • DBCC CHECKDB
  • DBCC CHECKFILEGROUP
  • DBCC CHECKTABLE
  • DBCC INDEXDEFRAG
  • DBCC SHRINKDATABASE
  • DBCC SHRINKFILE
  • KILL
  • RESTORE DATABASE
  • UPDATE STATISTICS

    • Paul

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

  • June 6, 2013 at 9:21 am

    #1621792

    I have checked percent_complete and Estimated_COmpletion_time for my large table during index creation. It shows both columns are zero.

    Is there any other way can find the index progression?

    • Viewing 3 posts - 1 through 2 (of 2 total)

    You must be logged in to reply to this topic. Login to reply