Database Monitor (SAP DB) 

 

You can use the database monitor to display the most important statistics for an analysis of database activity. This provides you with an overview of database performance and supports your monitoring of the database system.

Prerequisite

You are assigned the SAP DB administrator role.

Procedure

In the SAP_BC_DB_ADMIN_SAPDB role: choose Monitoring ® Database assistant (transaction DB50 ). The screen SAP DB: System Monitoring Analysis appears.

Then choose Database: Performance and Configuration ® Database Performance Analysis (transaction ST04 ).

The statistics are arranged according to the following areas:

Cache Activity

Commands

I/O Activity

Locking Activity

Logging Activity

Scan and Sort Activity

You can also use the Database Alert Monitor for further analysis.

See also:

DBA Action Logs

The Alert Monitor (Release 4)