Question: I’ve issued a DBCC SHRINKDATABASE on a 1.1 TB database. It’s been running awhile and business users are keen to know the estimated percent complete and estimated finish time . How can I find out this information?

Answer: Using the SQL Server DMV sys.dm_exec_requests , assists in estimating the finish time. The percent_complete and estimated_completion columns are useful.

While the DBCC SHRINKDATABASE is running – run the query below without the session_id.

Look for a record with DbccSpaceReclaim , DbccFilesCompact or DbccLOBCompact in the command column.