An important part of the database administrator's work is to perform regular checks of the system. Any problems must be detected and eliminated as early as possible in order to limit the subsequent damage inflicted on the system. Important tasks that should be part of the normal checking routine are database error log analysis, disk space monitoring and database consistency checks. Both the SAP system and the SQL Server Management Studio provide functions to perform these tasks.
Features
Error Log Display
The SQL Server error log informs you whether operations such as backup or restore have been completed successfully and whether any problems have arisen in the system. To access the error log, use one of these:
Disk Space Monitoring
The SQL Server Management Studio and the SAP database monitors offer various options to view the size of the SAP database and transaction log:
For more information, seeMonitoring the SAP Data Disk
For more information, seeMonitoring the SAP Data Disk
For more information, seeMonitoring the SAP Log Disk
Database Consistency Checks
The SAP system provides a number of checks that enable you to determine whether the database is consistent:
For more information, seeChecking Consistency of the Database
For more information, seeChecking Consistency of Individual Tables
For more information, seeMissing Tables and Indexes