| 16 | Differential Changed Map | DIFF_MAP_PAGE | 自最后一条BACKUP DATABASE语句之后更改的区的信息 |
| 17 | Bulk Changed Map | | 自最后一条BACKUP LOG语句之后的大容量操作锁修改的区的信息 |
| 18 | | | a page that’s be deallocated by during a repair operation |
| 19 | | | the temporary page that (or DBCC INDEXDEFRAG) uses when working on an index |
| 20 | | | a page pre-allocated as part of a bulk load operation, which will eventually be formatted as a ‘real’ page |
另外,关于
sys.dm_db_database_page_allocations
的输出字段信息如下所示(搜索相关资料结合自己的理解,如果错误,敬请指出):
| 字段 | 中文字段描述 | 英文描述 |
| database_id | 数据库ID | ID of the database |
| object_id | 表或视图对象的ID | Object ID For the table or view |
| index_id | 索引ID | ID for the index |
| partition_id | 索引的分区号 | Partition number for the index |
| rowset_id | 索引的Partition ID | Partition ID for the index |
| allocation_unit_id | 分配单元的 ID | ID of the allocation unit |
| allocation_unit_type | 分配单元的类型 | Type of allocation unit |
| allocation_unit_type_desc | 分配单元的类型描述 | Description for the allocation unit |
| data_clone_id | | ? |
| clone_state | | ? |
| clone_state_desc | | ? |
| extent_file_id | 区的文件ID | File ID of the extend |
| extent_page_id | 区的文件ID | Page ID for the extend |
| allocated_page_iam_file_id | 与页面关联的索引分配映射页面的文件ID |