Last night, my nightly CHECKDB errored out:
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Unable to read and latch page (1:1151632) with latch type SH. Latch failed.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDatabase'.
I manually ran CHECKDB this morning and got no errors:
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MyDatabase'.
Do I have reason to be worried? Is there a way of figuring out what caused the CHECKDB failure last night? CHECKDB on the system databases found no problems, tempdb is set to unrestricted growth and there is plenty of space on the drive where tempdb lives.