You can use this to monitor 
    *     backup / restore
    *     dbcc checkdb / checktable / etc.
    *     dbcc shrinkdatabase / shrinkfile
    *     dbcc indexdefrag
    *     alter index reorganize
    *     rollback operations
SELECT percent_complete, (estimated_completion_time/60000) 'Estimated Completion Time in Minutes') FROM SYS.DM_EXEC_REQUESTS 
WHERE percent_complete <> 0
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment