Wednesday, October 23, 2013

How to check Shrink Process Progress

SELECT
 percent_complete,
 start_time,
 status,
 command,
 estimated_completion_time,
 cpu_time,
 total_elapsed_time
FROM
 sys.dm_exec_requests
WHERE
 command = 'DbccFilesCompact'

No comments:

Post a Comment