Detail Analysis Menu (SAP DB) 

You can display information for a database performance analysis and detailed database monitoring using the Detail analysis menu.

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.

Choose Detail Analysis Menu.

The information is separated into the following categories:
- Database activity analysis
 - Exceptional conditions analysis
 – Performance analysis tools

Choose Configuration to display both the current configuration values of the database management system and the current amount of storage space.

Database Activity Analysis

Database Processes

I/O Statistics

Cache Statistics

Region Statistics

DB Filling Statistics

Runtime Environment

Parameter Changes

Logging Statistics

Storage Overview

Database Assistant

Exclusive Lock Waits

Tables/Indexes

 

Exceptional Conditions Analysis

Control Log File

Database Message Log

Overview

 

Performance Analysis Tools

Diagnostic Monitor

Bottleneck Analysis

Performance Database

 

See also:

Database Monitor

Database Alert Monitor

The Alert Monitor (Release 4)

DBA Action Logs