Question

You manage a 6 TB SQL Server database on an Azure VM. The nightly maintenance window is short, and a full DBCC CHECKDB currently exceeds the window, causing significant tempdb pressure and I/O contention with backups. You must still detect the most common forms of on-disk corruption (torn pages, checksum failures) within the available window. Which approach best meets these requirements?

Accepted Answer

Run DBCC CHECKDB WITH PHYSICAL_ONLY on the schedule, and periodically run a full DBCC CHECKDB during a longer maintenance window

Answer

Run DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS every night to reduce output overhead

Answer

Disable page verification (PAGE_VERIFY NONE) to reduce I/O and rely on backups to detect corruption

Answer

Run DBCC CHECKDB WITH TABLOCK on the schedule to avoid creating an internal database snapshot