Database Alert Monitor (SAP DB) (SAP Library

Database Alert Monitor (SAP DB)

For information about the alert monitor (Release 4), see The Alert Monitor (Release 4).

Prerequisite

You are assigned the SAP DB administrator role.

Procedure

In the SAP_BC_DB_ADMIN_SAPDB role: choose Monitoring ® Database assistant (transaction DB50 ).

Choose Utilities ® Database Alert Monitor.

Result

The database alert monitor information is displayed under SAP DB.

Green means that the database is OK. The database administrator does not need to intervene.

Yellow or red means that this state puts the production operation of the database at risk. The database administrator must determine the cause of the alert and fix the problem.

	Explanation
SpaceManagement	Displays the free memory space in your database system. Checking Database Free Space Data Area: Displays the amount of free data space (%). The delivered preset threshold is set to generate a yellow alert when the free space is less than 30%. A red alert is generated when free space is less than 10%. To change these settings, use transaction RZ21 . Log Area: Displays the amount of free log space (%).The delivered preset threshold is set to generate a yellow alert when the free space is less than 33%. A red alert is generated when free space is less than 5%. If a yellow or red alert is displayed, back up the log area to ensure enough space is available in the log area for new log entries. If no log entries can be written, the database crashes.
Performance	Displays performance-relevant measurements. If yellow or red alerts are displayed, performance will be worse. Optimizer Statistics: Indicates whether optimizer statistics need to be updated. This checks both the last optimizer check and the current update statistics. If the last check is older than 30 days, a yellow alert appears; if older than 90 days, a red alert appears. If the last update statistics is older than 30 days, a yellow alert appears; if older than 60 days, a red alert appears. Caches: The data cache and converter cache hit rates are determined every 120 seconds. If the data cache hit rate falls below 99%, a yellow alert appears; below 96%, a red alert appears. If the converter cache hit rate falls below 98%, a yellow alert appears; below 94%, a red alert appears. Use transaction RZ21 to change threshold values. Bad Indexes: Checks whether there are any corrupt indexes in the database. Corrupt indexes cannot be used for the strategy selection and must be re-created using the administration tool. If there is a defective index in the system, a red alert appears.
Backup/Restore	Indicates whether the existing data backups satisfy the security criteria for your database system. Data Backup: Last Data Backup: Indicates how old the last successful data backup is (in days). If the backup is more than seven days old, a yellow alert appears; if older than 14 days, a red alert appears. You can also use the DBA action log display. Double-clicking an alert in this transaction brings you directly to the display in transaction DB12 . If necessary, schedule a backup in the DBA Planning Calendar. Backup Return Code: Checks whether the last backup was successful. If the last backup had errors, a red alert appears.
Health	Indicates whether the system is error-free. Data Devspaces: This alert is not yet supported.

See also:

Database Monitor

Detail Analysis Menu