This exceptional new edition gives you step-by-step instruction to optimize the performance of your SAP system and ensure it operates as cost-effectively as possible. Learn quickly how to systematically identify and analyze performance problems, implement appropriate tuning measures, and evaluate their effectiveness. SAP Performance Optimization Guide covers both technical optimization as well as the monitoring of applications. Each potential performance pitfall is highlighted along with corresponding instructions and valuable tips, provided directly from support professionals at SAP. Also included are the most important answers and clear illustrations generated over many years via two remote services provided by SAP: EarlyWatch and GoingLive Check.
New in this Edition
Completely revised and expanded, the Fourth Edition has also been significantly improved with the addition of all-new sections on Java performance using JARM. Plus, the chapter on DB monitors has been entirely updated and enhanced with all-new details on MaxDB.
Highlights Include:
Best practices for performance management
Techniques for monitoring hardware, database and SAP BASIS
Tips for central monitoring and workload analysis
Performance analysis for ABAP programs
Insights on workload distribution
Expert advice on interfaces
SAP GUI, BSPs and Java implementation
How to configure memory areas
SAP table buffering, locks, optimizing SQL statements
...and much more!
About the Author(s):
Thomas Schneider is responsible for monitoring issues, performance analysis and hardware sizing as a member of the SAP Active Global Support team. He has been working at SAP since 1996.
Table of Contents:
Foreword to the Series of Books ... 13
Acknowledgments ... 15
Introduction ... 17
1. Performance Management of a mySAP Solution ... 29
... 1.1 mySAP Solution Architecture ... 29
... 1.2 The Monitoring and Optimization Plan for a mySAP Solution ... 38
... 1.3 Summary ... 68
2. Monitoring Hardware, Database and SAP Basis ... 71
... 2.1 Basic Terms ... 71
... 2.2 Monitoring Hardware ... 72
... 2.3 Monitoring the Database ... 81
... 2.4 Analyzing SAP Memory Management ... 101
... 2.5 Analyzing SAP Work Processes ... 109
... 2.6 Summary ... 119
3. Workload Analysis ... 123
... 3.1 The Workload Monitor ... 124
... 3.2 Workload Analysis ... 128
... 3.3 Performing Workload Analysis ... 136
... 3.4 Application Monitor ... 147
... 3.5 Cross-Component Workload Analysis ... 150
... 3.6 Summary ... 154
4. Identifying Performance Problems in ABAP and Java Programs ... 157
... 4.1 Single Record Statistics ... 157
... 4.2 Central Single Record Statistics (Functional Trace) ... 161
... 4.3 Performance Trace ... 163
... 4.4 Performance Analysis With ABAP Trace (Runtime Analysis) ... 173
... 4.5 Analyzing Memory Usage with ABAP Debugger ... 180
... 4.6 Performance Statistics for J2EE Applications (JARM) ... 183
... 4.7 Summary ... 188
5. Workload Distribution ... 191
... 5.1 SAP Services ... 191
... 5.2 Dynamic User Distribution (Logon-Groups) and Operation Modes ... 198
... 5.3 Update Processing ... 202
... 5.4 Hardware Sizing ... 208
... 5.5 Planning the System Landscape ... 219
... 5.6 Summary ... 222
6. Interfaces ... 225
... 6.1 RFC Fundamentals ... 225
... 6.2 Interfaces to External Systems ... 230
... 6.3 Summary ... 241
7. SAP GUI and Internet Connection ... 243
... 7.1 SAP GUI 4.6 ... 243
... 7.2 SAP Web Application Server (SAP Web AS) ... 251
... 7.3 SAP Internet Transaction Server (SAP ITS) ... 252
... 7.4 Business Server Pages (BSP) and Internet Communication Manager
(ICM) ... 263
... 7.5 SAP J2EE Engine ... 272
... 7.6 End-to-End Performance Monitoring ... 279
... 7.7 Summary ... 283
8. Memory Management ... 287
... 8.1 Memory Management Fundamentals ... 287
... 8.2 Configuring and Monitoring SAP Memory Areas ... 299
... 8.3 Summary ... 318
9. SAP Table Buffering ... 321
... 9.1 Preliminary Remarks Concerning Chapters 9, 10 and 11 ... 322
... 9.2 Table Buffering Fundamentals ... 323
... 9.3 Monitoring SAP Table Buffering ... 333
... 9.4 Summary ... 348
10. Locks ... 351
... 10.1 Database Locks and SAP Enqueues ... 351
... 10.2 Monitoring Database Locks ... 354
... 10.3 Number Range Buffering ... 359
... 10.4 ATP Server ... 365
... 10.5 Summary ... 371
11. Optimizing SQL Statements ... 373
... 11.1 Identifying and Analyzing Expensive SQL Statements ... 373
... 11.2 Optimizing SQL Statements Through Secondary Indexes ... 379
... 11.3 Optimizing SQL Statements in the ABAP Program ... 400
... 11.4 Summary and Related Tuning Measures ... 419
Appendix ... 425
... A. Performance Analysis Roadmaps and Checklists ... 425
... B. Database Monitors, Buffers, and SQL Execution Plans ... 441
... C. Configuration Performance Parameters ... 471
... D. Selected Transaction Codes ... 483
... E. Review Questions and Answers ... 485
... F. Glossary ... 497
... G. Information Sources ... 507
... H. Selected SAP Service Marketplace Notes ... 509
Index ... 513
