SQL SERVER � SQL Daily Tips � Monitoring progress for tasks. | Backup Server Tips

11:29:00 PM

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.

Artikel Terkait

Previous
Next Post »