Abnormal Blues

TA

Monitor / Tool

Task

Goal

CCT-Concept Check Tool

Use alongside project during first two ASAP phases

Analysis of project and implementation work, project organization and configuration of the R/3 System

Report with information on optimizing system configuration

List possible sources of errors in process flow and Customizing

List critical datasets

SE30

Runtime analysis

Runtime analysis of ABAP programs, transactions, function modules, database accesses, and the R/3 System

Reduction of CPU load on the application server

ST14

Application analysis

Analysis of processes using spot checks and values gained from experience, mainly in SD processing

Statistical key figures for optimizing process flow, e.g. price determination

ST03

SQL - Trace

SAP locks (enqueues)

RFC - Trace

Display of conversion of OPEN-SQL commands into SQL commands of the database including the transfer of parameters

Analysis of access strategy (use of indexes) and the DB optimizer using function EXPLAIN

Caution: No display of read accesses for buffered tables!

Analysis of SAP lock logic

Analysis of the number and runtime of RFC calls

Reduction and optimization of database accesses Optimization of options for parallel processing, reduction of locks and enqueue server load Optimization of communication times between various systems

DB01

Database locks

Analysis of locks on the database

Optimization of options for parallel processing

ST04

Database process overview

Overview of the processes of the DBMS

Reduction and optimization of database accesses, optimization of the DBMS

DB05

Analysis of key fields of the database

Display of the selectivity of DB fields, help for decision-making regarding creating invoices and buffering tables

Optimization of indexes

ST10

Overview of table calls

Analysis of table access

Optimization of table buffering

SM66

Global work process overview

Overview of all active work processes on all available application servers and their user assignment and the programs executed

Optimization of processing in a multi-user environment

SM50

Detailed work process overview

Analysis of a single work process

Optimization of processing

ST06

Operating system overview

Overview of CPU, main memory and hard disks

Finding bottlenecks in the system

ST02

Overview of memory and buffer use

Analysis of main memory usage, buffer quality and table calls

Optimization of main memory usage and buffers