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
SQL SERVER � Working with LSN for Restore and Backup Databases. (Error: Msg 4305, Level 16, State 1, Line 1) | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* Fo- SQL SERVER � TIPS � Reclaim space for a table after drop column. | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* Fo
- SQL SERVER � Checkpoint | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* Fo
- SQL SERVER � SQL Real Cases � Issue with auto_close option (Root cause of SUSPECT database). | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* Fo
EmoticonEmoticon