DBCC IND是一个非正式的命令,用于定位到表或索引使用的Page,该命令的语法结构是:
DBCC IND ( ['database name'|database id], table_name,index_id)
参数index_id的有效值是:
- 1:表示表的聚集索引
- 非聚集索引的index_id
- 0:代表堆(没有创建聚集索引的表)
- -1:表示跟表相关的所有类型的Page(in row data, row over flow data, IAM, all indexes)
- -2:只显示IAM类型的Page
该命令返回的结果如下所示:
结果集中各个字段的含义:
- PageFID — the file ID of the page
- PagePID — the page number in the file
- IAMFID — the file ID of the IAM page that maps this page (this will be NULL for IAM pages themselves as they’re not self-referential)
- IAMPID — the page number in the file of the IAM page that maps this page
- ObjectID — the ID of the object this page is part of
- IndexID — the ID of the index this page is part of
- PartitionNumber — the partition number (as defined by the partitioning scheme for the index) of the partition this page is part of
- PartitionID — the internal ID of the partition this page is part of
- iam_chain_type — see IAM chains and allocation units in SQL Server 2005
- PageType — the page type. Some common ones are:
- 1 – data page
- 2 – index page
- 3 and 4 – text pages
- 8 – GAM page
- 9 – SGAM page
- 10 – IAM page
- 11 – PFS page
- IndexLevel — what level the page is at in the index (if at all). Remember that index levels go from 0 at the leaf to N at the root page
- NextPageFID and NextPagePID — the page ID of the next page in the doubly-linked list of pages at this level of the index
- PrevPageFID and PrevPagePID — the page ID of the previous page in the doubly-linked list of pages at this level of the index