Per-Table Logical Consistency Checks
These checks verify the consistency for all structures in a table and all its indexes. In this section, when I say "a table," I mean "all partitions of the heap or clustered index, all partitions of all nonclustered indexes, and any off-row LOB data." The table could be a regular table, an indexed view, an XML index, a system catalog, a spatial index, a Service Broker queue, or any other database object that is stored internally as a table.
All the tables within a single batch are checked at the same time, using the fact-generation and fact-aggregation algorithms described previously. The first batch contains the critical system tables, and then subsequent batches are built and checked until all tables in the ...
Get Microsoft® SQL Server® 2008 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
