Hello Everyone,
Do you know that SQL Server 2005 provide us an way to monitor what’s the current progress (Percentage Complete and Estimated Completion time) of some of the maintenances we do regularly.
Following are the activities that can be monitored:
DBCC CHECKDB
DBCC CHECKTABLE
DBCC CHECKFILEGROUP
DBCC CHECKALLOC
DBCC SHRINKFILE
DBCC SHRINKDATABASE
ALTER INDEX (Only when we use REORGANIZE option)
Command to monitor:
select
session_id,command,cpu_time,percent_complete,estimated_completion_time
from
sys.dm_exec_requests
Note: Again the performance of the commands depends on various factors, but the above SQL gives an good indication on how we are progressing. Unfortunately not all the activities can be monitored
Best regards,
Ethiraj