Progress of Completion

SELECT

      command,

      percent_complete,

      estimated_completion_time,

      r.estimated_completion_time / 60000 as estimated_completion_time_mins,

      cpu_time,

      total_elapsed_time,

      total_elapsed_time / 60000 as total_elapsed_time_mins,

      ST.TEXT

FROM sys.dm_exec_requests r

      CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st

WHERE command in( 'RESTORE DATABASE', 'BACKUP DATABASE')

Percentage of work completed for the following commands:

·         ALTER INDEX REORGANIZE

·         AUTO_SHRINK option with ALTER DATABASE

·         BACKUP DATABASE

·         DBCC CHECKDB

·         DBCC CHECKFILEGROUP

·         DBCC CHECKTABLE

·         DBCC INDEXDEFRAG

·         DBCC SHRINKDATABASE

·         DBCC SHRINKFILE

·         RECOVERY

·         RESTORE DATABASE,

·         ROLLBACK

·         TDE ENCRYPTION