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
