| title | sys.dm_hadr_auto_page_repair (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_hadr_auto_page_repair (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server]
Returns a row for every automatic page-repair attempt on any availability database on an availability replica that is hosted for any availability group by the server instance. This view contains rows for the latest automatic page-repair attempts on a given primary or secondary database, with a maximum of 100 rows per database. As soon as a database reaches the maximum, the row for its next automatic page-repair attempt replaces one of the existing entries.
The following table defines the meaning of the various columns:
| Column name | Data type | Description |
|---|---|---|
| database_id | int | ID of the database to which this row corresponds. |
| file_id | int | ID of the file in which the page is located. |
| page_id | bigint | ID of the page in the file. |
| error_type | int | Type of the error. The values can be: **-**1 = All hardware 823 errors 1 = 824 errors other than a bad checksum or a torn page (such as a bad page ID) 2 = Bad checksum 3 = Torn page |
| page_status | int | The status of the page-repair attempt: 2 = Queued for request from partner. 3 = Request sent to partner. 4 = Page was successfully repaired. 5 = The page could not be repaired during the last attempt/ Automatic page repair will attempt to repair the page again. |
| modification_time | datetime | Time of last change to the page status. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Automatic Page Repair (Availability Groups: Database Mirroring)
suspect_pages (Transact-SQL)
Manage the suspect_pages Table (SQL Server)