Abstract: Sometimes it might be needed to shrink an Sharepoint SQL Database via the Microsoft SQL Management Studio GUI.The issue here is depending on the size, it might take some time and the GUI will now show the process. So how can the process be checked?

Normally such SQL tasks are done together with an Microsoft SQL Database Administrator (DBA), but if there is no DBA an Sharepoint administrator (if he has the needed SQL rights) he can check the process with the following SQL statement:

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

It should output something like

percent_complete start_time status command estimated_completion_time cpu_time total_elapsed_time
---------------- ----------------------- ------------------------------ ---------------- ------------------------- ----------- ------------------
93.23543 2017-02-13 21:33:21.150 suspended DbccFilesCompact 2934 2632 64422

Here you can find the needed infos like the overall completion percent from the compact action.

Cross information:
https://blogs.msdn.microsoft.com/psssql/2008/03/28/how-it-works-sql-server-2005-dbcc-shrink-may-take-longer-than-sql-server-2000/

 

Leave your comments

Post comment as a guest

0

Comments

    • No comments found