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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.