Question

You manage a SQL Server 2022 instance running on an Azure virtual machine that hosts a 2 TB production database. Management requires proactive detection of physical page corruption before it causes application errors, and the maintenance activity must run during a nightly window with minimal impact on production workloads. Which approach best meets this requirement?

Accepted Answer

Schedule a SQL Server Agent job that runs DBCC CHECKDB with the PHYSICAL_ONLY option during the nightly maintenance window.

Answer

Enable Query Store and review the wait statistics report each morning for corruption-related waits.

Answer

Rely on the automatic page repair feature by configuring an Always On availability group replica.

Answer

Schedule a nightly job that rebuilds all clustered indexes to overwrite any corrupted pages.