SQLSERVER 页面类型 状态A的值 记录类型

SQLSERVER 页面类型  状态A的值 记录类型

namespace InternalsViewer.Internals.Records
{
    public enum RecordType
    {
        Primary = 0,
        Forwarded = 1,
        Forwarding = 2,
        Index = 3,
        Blob = 4,
        GhostIndex = 5,
        GhostData = 6,
        GhostRecordVersion = 7
    }
}

 

     protected static string GetRecordTypeDescription(RecordType recordType)
        {
            switch (recordType)
            {
                case RecordType.Primary: return "Primary Record";
                case RecordType.Forwarded: return "Forwarded Record";
                case RecordType.Forwarding: return "Forwarding Record";
                case RecordType.Index: return "Index Record";
                case RecordType.Blob: return "BLOB Fragment";
                case RecordType.GhostIndex: return "Ghost Index Record";
                case RecordType.GhostData: return "Ghost Data Record";
                case RecordType.GhostRecordVersion: return "Ghost Record Version";
                default: return "Unknown";
            }
        }

 

internals viewer代码

namespace InternalsViewer.Internals.Pages
{
    /// <summary>
    /// Page Type
    /// </summary>
    public enum PageType
    {
        /// <summary>
        /// 
        /// </summary>
        None = 0,
        /// <summary>
        /// 
        /// </summary>
        FileHeader = 15,
        /// <summary>
        /// 
        /// </summary>
        Data = 1,
        /// <summary>
        /// 
        /// </summary>
        Index = 2,
        /// <summary>
        /// 
        /// </summary>
        Lob3 = 3,
        /// <summary>
        /// 
        /// </summary>
        Lob4 = 4,
        /// <summary>
        /// 
        /// </summary>
        Sort = 7,
        /// <summary>
        /// 
        /// </summary>
        Gam = 8,
        /// <summary>
        /// 
        /// </summary>
        Sgam = 9,
        /// <summary>
        /// 
        /// </summary>
        Iam = 10,
        /// <summary>
        /// 
        /// </summary>
        Pfs = 11,
        /// <summary>
        /// 
        /// </summary>
        Boot = 13,
        /// <summary>
        /// 
        /// </summary>
        Dcm = 16,
        /// <summary>
        /// 
        /// </summary>
        Bcm = 17
    }
}

类型	页面类型名称	页面类型描述
1	Data page	堆表和聚集索引的叶子节点数据
2	Index page	聚集索引的非叶子节点和非聚集索引的所有索引记录
3	Text mixed page	A text page that holds small chunks of LOB values plus internal parts of text tree. These can be shared between LOB values in the same partition of an index or heap.
4	Text tree page	A text page that holds large chunks of LOB values from a single column value.
7	Sort page	排序时所用到的临时页，排序中间操作存储数据用的。
8	GAM page	全局分配映射（Global Allocation Map，GAM）页面 这些页面记录了哪些区已经被分配并用作何种用途。
9	SGAM page	共享全局分配映射（Shared Global Allocation Map，GAM）页面 这些页面记录了哪些区当前被用作混合类型的区，并且这些区需含有至少一个未使用的页面。
10	IAM page.	有关每个分配单元中表或索引所使用的区的信息
11	PFS page.	有关页分配和页的可用空间的信息
13	boot page.	记录了关于数据库的信息，仅存于每个数据库的第9页
15	file header page	记录了关于数据库文件的信息，存于每个数据库文件的第0页
16	DCM page	记录自从上次全备以来的数据改变的页面，以备差异备份
17	BCM page	有关每个分配单元中自最后一条 BACKUP LOG 语句之后的大容量操作所修改的区的信息