May 23, 2018 at 4:13 pm
I have dbcc checkdb running on a 2 GB database but it takes about 1 minute to complete. In sys.dm_exec_requests i see DBCC is in running state and i don't see any wait type when i query sys.dm_os_waiting_tasks, the query sits in running state for most of the time. How do i see what is it exactly waiting on? Adam Mechanics sp_whoisactive does't show any wait type for this query.
May 25, 2018 at 9:06 am
If it is running is likely isn't waiting on anything it is executing the task that it needs to do. You should only see a wait if the query isn't in a running state. If DBCC CHECKDB Is finishing in a minute I don't think there is a performance issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 27, 2018 at 5:33 pm
Jack Corbett - Friday, May 25, 2018 9:06 AMIf it is running is likely isn't waiting on anything it is executing the task that it needs to do. You should only see a wait if the query isn't in a running state. If DBCC CHECKDB Is finishing in a minute I don't think there is a performance issue.
+1
June 8, 2018 at 12:39 am
This was removed by the editor as SPAM
June 11, 2018 at 11:32 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply