Please assist, While running DBCC checkdb() on my production server I am getting below error.
Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
I also executed Dbcc checkalloc('DBname') with estimateonly but that also is giving below message
Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Then I also executed Dbcc checkalloc('DBname') with no_infomsgs, all_errormsgs Which also give below error message
Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
This is SQL Server 2008 R2.
Can someone please assist me in resolving above issue.