Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > SQL Server checksum option

SQL Server checksum option

Storage subsystems are not perfect. For this reason Microsoft and SQL Server MVPs recommend that the checksum option be enabled. If an inconsistency occurs on the I/O subsystem, SQL Server immediately notices when a page is read rather than allow the application to be exposed to the inconsistency.

Enable the checksum option

By default, the checksum option is enabled. If the option is disabled in a database, perform the following steps:

  1. Open the SQL Server Management Studio.
  2. Right-click on a Database, and click Properties.
  3. Select the Options page.
  4. Locate the Page Verify option in the Recovery section.
  5. Change the Page Verify value to CHECKSUM, and click OK.
Last modified

Tags

Classifications

Public