ABAP Performance Tuning
1st Edition
Published on 26. July 2009
Book
Hardback
348 pages
978-1-59229-289-9 (ISBN)
Description
This book for ABAP developers details best practices for ABAP performance tuning. Covering the most critical performance-relevant programming issues and performance monitoring tools, this book will show you how to best analyze, tune, and implement your ABAP programs.Starting with a description of the client/server architecture, the book moves on to discussing the different tools for analyzing performance. Programming techniques are then analyzed in detail, based on numerous real-life examples. This book will help you ensure that your ABAP programs are tuned for best performance.
Highlights:
Analysis Tools: Code and Memory Inspector, Selectivity and Process Analysis, Debugger, Performance Trace, ABAP Trace, E2E Trace, Single Records Statistics
Parallel Processing
Data Processing with SQL: Access Strategies, Resulting Set, Index Design, Execution Frequency, APIs
Buffering: Buffering Types, Sessions, Shared Objects, Table Buffering
Internal Tables: Table Types, Reading, Changing and Deleting Tables, Secondary Indexes, Nested Loops
RFC Communication
More details
Person
Author
Hermann Gahm is an SAP Support Consultant in the Technology & Performance area, and he has worked in the Active Global Support department of SAP AG since 2007. His tasks focus on the support of major SAP customers with regard to performance problems within the scope of ABAP developments for CPO (Customer Program Optimization) and BPPO services (Business Process Performance Optimization).
While working as an ABAP developer at one of the largest commercial enterprises in Germany and as an SAP system administrator at the industry-leading enterprise for processing industrial credit and building society savings products, he finished his further training as an expert in business data processing at the IHK (German Chamber of Commerce and Industry). Here, his work focused on the performance analysis and optimization of mass data processing in SAP systems.
He then joined SAP SI AG as an SAP technology consultant where he took over responsibility for various system, database, and ABAP program tuning projects for national and international customers.
Content
1 ... Introduction ... 17
... 1.1 ... Tuning Methods ... 17
... 1.2 ... Structure of the Book ... 19
... 1.3 ... How to Use This Book ... 20
2 ... SAP System Architecture for ABAP Developers ... 21
... 2.1 ... SAP System Architecture ... 21
... 2.2 ... Performance Aspects of the Architecture ... 25
3 ... Performance Analysis Tools ... 29
... 3.1 ... Overview of Tools ... 29
... 3.2 ... Usage Time of Tools ... 31
... 3.3 ... Analysis and Tools in Detail ... 34
... 3.4 ... Tips for the Performance Analysis ... 123
... 3.5 ... Summary ... 124
4 ... Parallel Processing ... 127
... 4.1 ... Packaging ... 127
... 4.2 ... Parallel Processing ... 129
5 ... Data Processing with SQL ... 147
... 5.1 ... The Architecture of a Database ... 147
... 5.2 ... Execution of SQL ... 151
... 5.3 ... Efficient SQL: Basic Principles ... 155
... 5.4 ... Access Strategies ... 155
... 5.5 ... Resulting Set ... 185
... 5.6 ... Index Design ... 198
... 5.7 ... Execution Frequency ... 205
... 5.8 ... Used API ... 215
... 5.9 ... Special Cases and Exceptions ... 217
6 ... Buffering of Data ... 223
... 6.1 ... SAP Memory Architecture from the Developer's Point of View ... 223
... 6.2 ... User-Specific Buffering Types ... 227
... 6.3 ... Cross-User Buffering Types ... 232
... 6.4 ... SAP Table Buffering ... 236
... 6.5 ... Summary ... 251
7 ... Processing of Internal Tables ... 253
... 7.1 ... Overview of Internal Tables ... 253
... 7.2 ... Organization in the Main Memory ... 255
... 7.3 ... Table Types ... 258
... 7.4 ... Performance Aspects ... 265
8 ... Communication with Other Systems ... 287
... 8.1 ... RFC Communication Between ABAP Systems ... 288
... 8.2 ... Performance Aspects for the RFC Communication ... 290
... 8.3 ... Summary ... 293
9 ... Special Topics ... 295
... 9.1 ... Local Update ... 295
... 9.2 ... Parameter Passings ... 298
... 9.3 ... Type Conversions ... 299
... 9.4 ... Index Tables ... 299
... 9.5 ... Saving Frontend Resources ... 300
... 9.6 ... Saving Enqueue and Message Service ... 301
10 ... Outlook ... 303
... 10.1 ... Important Changes to the Tools for the Performance Analysis ... 303
... 10.2 ... Important Changes to Internal Tables (Secondary Key ... 314
A ... Execution Plans of Different Databases ... 319
... A.1 ... General Information on Execution Plans ... 319
... A.2 ... IBM DB2 (IBM DB2 for zSeries ... 320
... A.3 ... IBM DB2 (DB2 for iSeries) ... 323
... A.4 ... IBM DB2 (DB2 for LUW) ... 326
... A.5 ... SAP MaxDB ... 329
... A.6 ... Oracle ... 332
... A.7 ... Microsoft SQL Server ... 336
B ... The Author ... 339