DBCC shows corruption (test db) but suspect_pages shows nothing



  • So, I got a corrupted database. This is the DBCC:

    Msg 8944, Level 16, State 13, Line 4
    Table error: Object ID 2105058535, index ID 1, partition ID 72057594038845440, alloc unit ID 72057594039762944 (type In-row data), page (1:158), row 3. Test (ColumnOffsets Msg 8944, Level 16, State 13, Line 4
    Table error: Object ID 2105058535, index ID 1, partition ID 72057594038845440, alloc unit ID 72057594039762944 (type In-row data), page (1:158), row 3. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3139 and 288.

    Msg 8928, Level 16, State 1, Line 4
    Object ID 2105058535, index ID 1, partition ID 72057594038845440, alloc unit ID 72057594039762944 (type In-row data): Page (1:158) could not be processed. See other errors for details.

    Msg 8976, Level 16, State 1, Line 4
    Table error: Object ID 2105058535, index ID 1, partition ID 72057594038845440, alloc unit ID 72057594039762944 (type In-row data). Page (1:158) was not seen in the scan although its parent (1:159) and previous (1:156) refer to it. Check any previous errors.

    Great. now if I query Suspect_Pages, I don't see any signal of issues:

    enter image description here

    I read here that DBCC captures it and put it into the table, but I'm not sure why i don't see it there.

    https://www.stellarinfo.com/blog/monitor-sql-database-suspect-pages/



  • The https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/suspect-pages-transact-sql?view=sql-server-ver15 mentions only 823 and 824 errors are captured:

    Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect page is repaired, its status is updated in the event_type column.

    I suggest you start with the doc as the authoritative SQL Server reference.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2