DBCC CHECKDB job is throwing error:

Question

DBCC CHECKDB job is throwing error:

coolchaitu

SSChampion

Points: 10332
More actions
December 11, 2017 at 6:29 am

#325014

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

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

coolchaitu SSChampion Points: 10332 More actions · Answer 2

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

tempdb has 12407 MB free space. SQL Server is using 6 GB out of 8 GB RAM

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 3

coolchaitu - Monday, December 11, 2017 6:42 AM
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
tempdb has 12407 MB free space. SQL Server is using 6 GB out of 8 GB RAM

That's really not much memory, are you able to add any more?

Thanks

coolchaitu SSChampion Points: 10332 More actions · Answer 4

NorthernSoul - Monday, December 11, 2017 7:07 AM
coolchaitu - Monday, December 11, 2017 6:42 AM
NorthernSoul - Monday, December 11, 2017 6:36 AM
coolchaitu - Monday, December 11, 2017 6:29 AM
oGood 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
tempdb has 12407 MB free space. SQL Server is using 6 GB out of 8 GB RAM
That's really not much memory, are you able to add any more?
Thanks

No actually.