Skip to content

Latest commit

 

History

History
51 lines (41 loc) · 2.8 KB

sys-dm-hadr-auto-page-repair-transact-sql.md

File metadata and controls

51 lines (41 loc) · 2.8 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.dm_hadr_auto_page_repair (Transact-SQL)
sys.dm_hadr_auto_page_repair (Transact-SQL)
rwestMSFT
randolphwest
02/27/2023
sql
system-objects
reference
dm_hadr_auto_page_repair_TSQL
sys.dm_hadr_auto_page_repair
sys.dm_hadr_auto_page_repair_TSQL
dm_hadr_auto_page_repair
Availability Groups [SQL Server], monitoring
automatic page repair
sys.dm_hadr_auto_page_repair dynamic management view
TSQL

sys.dm_hadr_auto_page_repair (Transact-SQL)

[!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.

Permissions

Requires VIEW SERVER STATE permission on the server.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

See also

Automatic Page Repair (Availability Groups: Database Mirroring)
suspect_pages (Transact-SQL)
Manage the suspect_pages Table (SQL Server)