Show TOC

Checking Consistency of the DatabaseLocate this document in the navigation structure

Use

A database consistency check performs a thorough check of the entire database. It examines all tables in the database to find out whether index and data pages are correctly linked and indexes are in proper-sorted order. It also checks that all pointers are consistent and that the data information on each page, and page offsets are reasonable. It enables the early recognition of problems and thus prevents problem escalation and possible loss of data.

Schedule the consistency checks with the DBA Planning Calendar. For more information, seeScheduling Database Consistency Check (Windows). Checks should run at the weekend when you have time. When the check runs, no other task should be scheduled.

Note

At the SQL Server level, the SAP database consistency check executes the DBCC CHECKDB command. This typically locks user tables, indexes and system tables when running. In addition, it is very I/O intensive and should therefore not be run during normal operation, but at times when the system load is low. For more information, see SAP Note 142731 DBCC Checks of SQL Server.