When the database CHECKDB task gets completed .This does is a frequent question asked my Team Leads/Managers or else any one. Buy UN fortunately SQL Server Management Studio does not help us n o this. No Worries we from SQL Server 2005 and above we have DMV to help us out.

use master
SELECT session_id ,percent_complete ,estimated_completion_time ,DATEADD(ms,estimated_completion_time,GETDATE()) AS Time_to_Complete,
start_time,status ,command FROM sys.dm_exec_requests WHERE command like ‘%DBCC%’

Leave a Reply

Your email address will not be published. Required fields are marked *