Hi SahaSaha-5270,
Thanks for your reply.
How do I check if DBCC CHECKDB command is in progress.
Please try this:
SELECT session_id ,
request_id ,
percent_complete ,
estimated_completion_time ,
DATEADD(ms,estimated_completion_time,GETDATE()) AS EstimatedEndTime,
start_time ,
status ,
command
FROM sys.dm_exec_requests
where command like '%DBCC%'
Best Regards,
Amelia