SQL Server: DBCC PAGE and DBCC IND to find a Data Page information

In the previous series of the articles, I have shared internal structure of the Data File and Data Page of the SQL Server.

In this article, I am going to share small practical demonstration to find Data Page information of a particular table of the SQL Server.

First, Create a table with sample data:

Execute DBCC IND to check allocated pages of a Table:
You should put your Database_Name. -1 means display all type of pages.

The Result:
PageFID is a file number and PagePID is a page number. You can use these numbers for further tracing.

SQL Server Data Page Information

Execute DBCC PAGE to find more information about the allocated page:
Syntax:

The Result:

SQL Server Page Header Information

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz