Tuesday, May 25, 2010

DB Monitoring–DB02

Use transaction code DB02 to monitor or troubleshoot database access performance.


From the main screen, browse to the entry “Session Monitor” from Performance > Wait Event Analysis



When a calculation/jobs is running, all database accesses will be shown on the right screen. This screen can be used to determine what queries are causing bottlenecks if there are performance issues.

The details available on this screen can be used in SAP OSS to look for support notes. As a starting point, you may refer to note number 745639 for common database performance issues.

No comments:

Post a Comment