Page flag and Page flag description for sys.dm_db_page_info

sakuraime 2,276 Reputation points
2020-08-24T09:55:15.97+00:00

anyone know the details about the following column ?
19857-page-flag.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,576 questions
No comments
{count} votes

3 answers

Sort by: Most helpful
  1. CathyJi-MSFT 20,671 Reputation points Microsoft Employee
    2020-08-25T03:02:39.513+00:00

    Hi ,

    page_flag_bits ------- Flag bits in page header

    page_flag_bits_desc ------ Flag bits description in page header

    Refer to sys.dm_db_page_info (Transact-SQL) and Pages and Extents Architecture Guide

    Best regards,
    Cathy

    No comments

  2. sakuraime 2,276 Reputation points
    2020-08-28T16:54:47.57+00:00

    so what does it means ? and what does it use for ??? what's the example ? what are the possible values and meaning ?

    No comments

  3. CathyJi-MSFT 20,671 Reputation points Microsoft Employee
    2020-09-02T08:58:37.93+00:00

    Hi @sakuraime ,

    I search this from Google, but did not find more details description of these columns.

    I found an old blog, this take an example page header dump from DBCC PAGE. This function is similar sys.dm_db_page_info.

    m_flagBits
    This stores a number of different flags that describe the page. For example, 0x200 means that the page has a page checksum on it (as our example page does) and 0x100 means the page has torn-page protection on it.

    Hope this could help you.

    Best regards,
    Cathy

    No comments