Sap systems

Thomas Schneider

SAP Performance Optimization Guide
®

Analyzing and Tuning SAP Systems

Contents
Foreword to the Series of Books Acknowledgments Introduction
Proactive Performance Management ............................................................ From SAP R/3 to mySAP Business Suite ...................................................... About This Book...............................................................................................

13 15 17
17 20 23

1
1.1

Performance Management of a mySAP Solution
mySAP Solution Architecture ......................................................................... 1.1.1 mySAP Solutions and SAP Components ......................................... 1.1.2 Client/Server Architecture................................................................ The Monitoring and Optimization Plan for a mySAP Solution ................ 1.2.1 Requirements of a Monitoring and Optimization Plan ................. 1.2.2 Tools and Methods for the Monitoring and Optimization Plan .. 1.2.3 Service Level Management .............................................................. 1.2.4 Continuous Monitoring.................................................................... 1.2.5 Plan for Continuous Performance Optimization ........................... 1.2.6 SAP Solution Manager ...................................................................... Summary ............................................................................................................

29
29 29 33 38 38 41 44 50 60 64 68

1.21.3

2
2.1 2.2

Monitoring Hardware, Database and SAP Basis
Basic Terms ........................................................................................................ Monitoring Hardware ...................................................................................... 2.2.1 Analyzing a Hardware Bottleneck (CPU and Main Memory) ....... 2.2.2 Analyzing Read/Write (I/O)Problems ........................................... 2.2.3 Other Checks With the Operating System Monitor ..................... 2.2.4 Summary .............................................................................................

71
71 72 73 78 80 80

Contents

5

2.3

Monitoring the Database ................................................................................81 2.3.1 Analyzing the Database Buffer ......................................................... 82 2.3.2 Identifying Expensive SQL Statements ............................................ 87 2.3.3 Identifying Read/Write (I/O) Problems ........................................... 93 2.3.4 Other Checks on the Database ........................................................ 94 2.3.5 Summary............................................................................................. 100 Analyzing SAP Memory Management .......................................................... 2.4.1 Analyzing SAP Buffers ....................................................................... 2.4.2 Analyzing SAP Extended Memory, SAP Heap Memory and SAP Roll Memory............................................................................... 2.4.3 Displaying the Allocated Memory ................................................... 2.4.4 Other Monitors in the Memory Configuration Monitor .............. 2.4.5 Summary ............................................................................................. Analyzing SAP Work Proces3ses................................................................... 2.5.1 Fields in the Work Process Overview ............................................. 2.5.2 Analyzing Work Processes ................................................................ 2.5.3 Systemwide Work Process Overview .............................................. 2.5.4 Monitoring the Dispatcher Queue .................................................. 2.5.5 Summary...