BeetleDev.com
info
contact
Saturday, December 15, 2018
Beetle Blog
Query status of shrinkdatabase
By: douglas - Sql Server - 11/26/2012 8:38:33 PM

DBCC shrinkdatabase( database_name ) can take a long time and it doesn't show progress if you run it via SSMS.  To view the percent complete use this query:

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

 


Last Modified: 11/26/2012 8:38:33 PM

Beetle Blog v0.2.2


Copyright © 1997 - 2018 BeetleDev.com. All rights reserved.