Performance Tuning Transactions

Performance tuning in the system can be done using a set of monitoring transaction codes for the application, database, and operating system. Table 22-2 lists the key performance tuning transactions and a brief description for each.

images

TABLE 22-2 SAP Performance Tuning Transactions

SQL Trace Overview

The following procedure can be used to get a SQL trace in a SAP system. SQL trace analysis will help us identify any expensive SQL statements and identify tuning/indexing opportunities to improve system performance.

Starting SQL Trace

The following procedure can be used to start a SQL trace for a program that is causing ...

Get SAP Basis Administration Handbook, NetWeaver Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.