Bookstore

This book describes how you can optimize the performance of your SAP solution and ensure it operates as cost-effectively as possible. Learn how to systematically identify and analyze performance problems, implement appropriate tuning measures, and evaluate their effectiveness. The book covers both technical optimization as well as the monitoring of applications. From hardware, to your ABAP and Java programs, to database access each potential performance bottleneck is highlighted, along with corresponding instructions and valuable tips provided directly from support professionals at SAP.

This fifth edition has been completely revised and updated for SAP NetWeaver 7.0. New sections cover topics related to the analysis of Web Dynpro applications, the SAP J2EE engine, SAP JVM, and SAP Solution Manager Diagnostics.

SAP Performance Optimization Guide 5e

1 Performance Management of an SAP Solution ... 35
... 1.1 ... SAP Solution Architecture ... 35
... 1.2 ... The Monitoring and Optimization Plan for an SAP Solution ... 46
... 1.3 ... Summary ... 69

2 Monitoring Hardware, Database, and SAP Basis ... 73
... 2.1 ... Basic Terms ... 73
... 2.2 ... Hardware Monitoring ... 75
... 2.3 ... Database Monitoring ... 85
... 2.4 ... Analyzing SAP Memory Configuration ... 106
... 2.5 ... Analyzing SAP Work Processes ... 115
... 2.6 ... Analyzing Java Virtual Machine (JVM) Memory Management and Work Processes ... 126
... 2.7 ... Analysis of the Internet Communication Manager (ICM) ... 134
... 2.8 ... Continuous Monitoring Using CCMS ... 135
... 2.9 ... Summary ... 145

3 Workload Analysis ... 149
... 3.1 ... Basics of Workload Analysis and Runtime Analysis ... 150
... 3.2 ... The Workload Monitor ... 155
... 3.3 ... Workload Analysis ... 160
... 3.4 ... Performing Workload Analyses ... 168
... 3.5 ... Application Monitor ... 179
... 3.6 ... The Central Workload Monitor ... 183
... 3.7 ... The Java Workload Monitor in SAP Solution Manager and the Introscope Monitor ... 188
... 3.8 ... Performing Workload Analysis for the SAP J2EE Engine ... 193
... 3.9 ... Summary ... 196

4 Identifying Performance Problems in ABAP and Java Programs ... 201
... 4.1 ... Single Record Statistics ... 201
... 4.2 ... Central Single-Record Statistics ... 206
... 4.3 ... Performance Trace ... 208
... 4.4 ... Performance Analysis with ABAP Trace (Runtime Analysis) ... 219
... 4.5 ... Analyzing Memory Usage with ABAP Debugger and in the Memory Inspector ... 227
... 4.6 ... Introscope Trace ... 231
... 4.7 ... End-to-End Runtime Analysis in SAP Solution Manager 233
... 4.8 ... Summary ... 236

5 Workload Distribution ... 241
... 5.1 ... Services of the SAP NetWeaver Application Server ... 241
... 5.2 ... Load Distribution Within the ABAP Application Instances ... 248
... 5.3 ... Hardware Sizing ... 266
... 5.4 ... Planning the System Landscape ... 276
... 5.5 ... Summary ... 281

6 Interfaces ... 285
... 6.1 ... RFC Fundamentals ... 285
... 6.2 ... Interfaces to External Systems ... 291
... 6.3 ... SAP Virtual Machine Container ... 303
... 6.4 ... Summary ... 305

7 SAP GUI and Internet Connection ... 307
... 7.1 ... SAP GUI ... 308
... 7.2 ... SAP NetWeaver Application Server ... 316
... 7.3 ... Analyses on the Presentation Server ... 320
... 7.4 ... Internet Transaction Server (ITS) ... 326
... 7.5 ... Business Server Pages (BSP), Web Dynpro for ABAP, and Integrated ITS ... 335
... 7.6 ... Java Server Pages and Web Dynpro for Java ... 344
... 7.7 ... Summary ... 348

8 Memory Management ... 353
... 8.1 ... Memory Management Fundamentals ... 353
... 8.2 ... Configuring and Monitoring SAP Memory Areas ... 366
... 8.3 ... Summary ... 387

9 SAP Table Buffering ... 391
... 9.1 ... Preliminary Remarks Concerning Chapters 9, 10, and 11 ... 392
... 9.2 ... Table Buffering Fundamentals ... 393
... 9.3 ... Monitoring Table Buffering on the ABAP Server ... 405
... 9.4 ... Monitoring the Table Buffering on the SAP J2EE Engine ... 422
... 9.5 ... Summary ... 424

10 Locks ... 427
... 10.1 ... Database Locks and SAP Enqueues ... 427
... 10.2 ... Monitoring Database Locks ... 431
... 10.3 ... Number Range Buffering ... 436
... 10.4 ... ATP Server ... 443
... 10.5 ... Summary ... 449

11 Optimizing SQL Statements ... 451
... 11.1 ... Identifying and Analyzing Expensive SQL Statements ... 451
... 11.2 ... Optimizing SQL Statements Through Secondary Indexes ... 458
... 11.3 ... Optimizing SQL Statements in the ABAP Program ... 481
... 11.4 ... Summary and Related Tuning Measures ... 501

Appendices ... 507
... A ... Performance Analysis Roadmaps and Checklists ... 509
... B ... Database Monitors, Buffers, and SQL Execution Plans ... 529
... C ... Configuration Performance Parameters, Key Figures, and SAP Notes ... 565
... D ... Selected Transaction Codes ... 591
... E ... Review Questions and Answers ... 595
... F ... Glossary ... 609