SQL SERVER – SQL Daily Tips – Monitoring progress for tasks.

SQL Server 2005 introduces Dynamic Management View, one of this objects allows us monitoring the progress for different tasks and process in SQL Server.

select percent_complete, estimated_completion_time, cpu_time, total_elapsed_time, *

from sys.dm_exec_requests

this query is very helpful in the daily work to monitoring different tasks.