Page flag and Page flag description for sys.dm_db_page_info

sakuraime 2,276 Reputation points

anyone know the details about the following column ?

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

    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,

    No comments

  2. sakuraime 2,276 Reputation points

    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

    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.

    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,

    No comments