http://www.sqler.com/389293/
http://www.sqler.com/bColumn/389293

select 
             er.command AS [명령어]
,            er.percent_complete AS [진행률(%)]
,            CONVERT(NUMERIC(10,2),er.estimated_completion_time/1000.0/60.0) AS [(분) 예상완료]
,            CONVERT(NUMERIC(10,2),er.estimated_completion_time/1000.0/60.0/60.0) AS [(시간) 예상완료]
,            st.text AS [구문]
from sys.dm_exec_requests AS er
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) AS st
WHERE er.session_id <> @@SPID

다른 쿼리는 수치가 정확한지 어떤지 모르겠으나 아래와 같은 작업에 도움이 된다는.. (현재 까지 진행된 현황을 백분율로 알 수 있음)

• ALTER INDEX REORGANIZE
  
• ALTER DATABASE의 AUTO_SHRINK 옵션
  
• BACKUP DATABASE
  
• CREATE INDEX
  
• DBCC CHECKDB
  
• DBCC CHECKFILEGROUP
  
• DBCC CHECKTABLE
  
• DBCC INDEXDEFRAG
  
• DBCC SHRINKDATABASE
  
• DBCC SHRINKFILE
  
• KILL(Transact-SQL)
  
• RESTORE DATABASE
  
• UPDATE STATISTICS