I'm running SQL Server 2008 R2 on Windows server 2008 R2 and up until recently we were having no problems. After windows updates recently (no sql server updates) we cannot run step 1 of our maintenance plan DBCC CHECKDB It does not error out, it just runs indefinitely, longest time so far 36 hours. The DB is only about 500MB so I dont think size is an issue.
I was just wondering if anyone has seen this sort of issue in the past.
Edit: For what it is worth I also noticed rebuilding index and updating statistics is having the same issue. I have no idea if this helps.
Edit2: So if if it helps anyone after running SELECT * FROM sys.dm_exec_requests; I'm seeing the wait type CXPACKET on the following tasks: ALTER INDEX, DBCC;
status
,wait_time
,wait_type
,last_wait_type
insys.dm_exec_requests