RSS

DBCC Page

18 Dec

http://www.mssqltips.com/sqlservertip/1578/using-dbcc-page-to-examine-sql-server-table-and-index-data/

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/12/13/more-undocumented-fun_3a00_-dbcc-ind_2c00_-dbcc-page_2c00_-and-off_2d00_row-columns.aspx

To figure out which objects the page belongs to, look for Metadata: ObjectId in the Header section of DBCC page. Use that object id to plug into the following command to obtain the object.

SELECT OBJECT_NAME(ObjectId)

 

 
 

Leave a comment