How To Check Shrink Database Progress?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
1. To check the progress of a shrink database operation, you can use the sys.dm_exec_requests dynamic management view. This view contains information about each request or session running on the SQL Server instance.
2. To check the progress of the shrink database operation, query the sys.dm_exec_requests view with the command below:
SELECT *
FROM sys.dm_exec_requests
WHERE command LIKE ‘DBCC SHRINKDATABASE%’
3. The output of the query will show the session ID and the command that is being executed. The percent_complete column will indicate the progress of the shrink database operation.
To check the progress of a shrink database task, open Microsoft SQL Server Management Studio and query the sys.dm_exec_requests system view. If the database you are shrinking is in the middle of a shrink operation, it will show up in the result set of this query. You can then view the percent_complete column to get an indication of how far along the shrink task has progressed.