Logging Statistics (SAP DB)
This information in the
Detail Analysis Menu provides information about the log status of your database system.You can see the:
If the fill level is above 60%, it is important to backup the completed log segments to free up space for future transactions. You can automate this process by activating
Automatic Log Backup (autosave log mechanism).
Log mode |
Explanation |
Demo |
Transaction log is overwritten cyclically after reaching a certain size (not recommended for production systems) |
Single |
Log segments are backed up |
Dual |
Log segments are backed up and mirrored (recommended for production systems) |
This section provides details about read/write log accesses. Read accesses are required for transaction rollbacks.
This contains information about savepoint and checkpoint activity since the last backup. Savepoints and checkpoints are used to ensure database system consistency and to write changed data pages from the data cache to the hard disk.
This provides, among other information, details about the log queue of the database system. The most important value in this list is the number of queue overflows. If the number of queue overflows is greater than zero, increase the LOG_IO_QUEUE database parameter.
See also:
Logging Activity
DBA Action Logs