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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
anyone know the details about the following column ?
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
so what does it means ? and what does it use for ??? what's the example ? what are the possible values and meaning ?
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