[AlwaysOn2017] DMV and DMF-Sys.dm_hadr_auto_page_repair of AlwaysOn

8 、 Sys. Dm_hadr_auto_page_repair

Returns a row for each automatic page repair attempt for any availability database that is located on an availability copy hosted by the server instance for any availability group. This view contains rows that correspond to the latest automatic page repair attempts on a given primary / secondary database, with a maximum of 100 rows per database. As long as the row corresponding to a database reaches the maximum value, the row corresponding to its next automatic page repair attempt replaces an existing item.

The following table defines the meaning of each column:

Column name

Data type

Description

Database_id

Int

The ID of the database corresponding to this row.

File_id

Int

The ID of the file where the page is located.

Page_id

Bigint

The ID of the page in the file.

Error_type

Int

Error type. The value can be:

-1 = all hardware 823 errors

Error other than checksum of error or page tearing (such as wrong page ID)

2 = wrong checksum

3 = page tearing

Page_status

Int

Status of the page repair attempt:

2 = queue for requests from partners.

3 = the request was sent to the partner.

4 = pages that have been successfully repaired.

5 = failed to repair the page during the last attempt / automatic page repair will attempt to repair the page.

Modification_time

Datetime

When the status of the page last changed.