Sample Header Ad - 728x90

Why does DBCC CHECKTABLE WITH TABLERESULTS only report Error 8990 on corrupt tables?

1 vote
1 answer
987 views
I have a production VLDB that I'm using Paul Randal's guidance on to spread DBCC CHECKDB workload over a week. I'm logging the results of DBCC CHECKTABLE WITH TABLERESULTS and DBCC CHECKALLOC WITH TABLERESULTS to a table an noticed DBCC CHECKTABLE WITH TABLERESULTS was only returning a single row per table on non-corrupt tables. Here's the first few columns. Error Level State MessageText 2593 10 1 There are 57 rows in 1 pages for object "SmallTable". But when I run DBCC CHECKTABLE WITH TABLERESULTS on a corrupt table in a test database, which I corrupted with this method , I get the following: Error Level State MessageText 8939 16 98 Table error: Object ID 565577053, index ID 1, partition ID 72057594041335808, alloc unit ID 72057594046971904 (type In-row data), page (1:312). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4. 8928 16 1 Object ID 565577053, index ID 1, partition ID 72057594041335808, alloc unit ID 72057594046971904 (type In-row data): Page (1:312) could not be processed. See other errors for details. 8980 16 1 Table error: Object ID 565577053, index ID 1, partition ID 72057594041335808, alloc unit ID 72057594046971904 (type In-row data). Index node page (0:0), slot 0 refers to child page (1:312) and previous child (0:0), but they were not encountered. 2593 10 1 There are 0 rows in 0 pages for object "tblWhoops". 8990 10 1 CHECKTABLE found 0 allocation errors and 3 consistency errors in table 'tblWhoops' (object ID 565577053). I'm curious as to why **Error 8990** ins't returned in with the non-corrupt table? DBCC CHECALLOC WITH TABLERESULTS and DBCC CHECKDB WITH TABLERESULTS return this row when there aren't any allocation or consistency errors to report. Bonus question, why doesn't DBCC CHECKCATALOG have a WITH TABLERESULT arguement?
Asked by S3S (3578 rep)
Oct 11, 2018, 12:46 AM
Last activity: Oct 11, 2018, 01:20 AM