NorthernSoul - Monday, December 11, 2017 6:36 AM

coolchaitu - Monday, December 11, 2017 6:29 AM

Good Morning Experts,

DBCC CHECKDB job is throwing below error:

. A timeout occurred while waiting for memory resources to execute the query in resource pool 'default' (2). Rerun the query. [SQLSTATE 42000] (Error 8645)  Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent.

Could you please let me know how to resolve this and proceed

Have you checked if tempdb is out of space as it mentions? How much memory do you have on the server and the instance?

Thanks