Page Verification Option

When SQL Server writes data to a page, it can either assume the data was written correctly or test to make sure it was valid. Having the page verification options set to CHECKSUM provides an efficient way to perform the check.

CHECKSUM is the default for new databases but is often set to TORN_PAGE when databases have been restored from older versions of SQL Server.

Suggested Action

Set the page verify option to CHECKSUM.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

Page Verification Not Optimal | Brent Ozar