Create index progress.

• Pravin Patel-491467

  Say Hey Kid

  Points: 674

  More actions

  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.

• Paul White

  SSC Guru

  Points: 150468

  More actions

  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