SAP Performance Optimization Guide

Dr. Thomas Schneider started his career at SAP AG in 1996. Among other things, he was in charge of the Center of Expertise for Performance in the Service & Support group and the responsible Support Alliance manager for key accounts. Since 2004 he has worked in the Research & Breakthrough Innovation group, where he first was responsible for IT Service & Application Management. Since 2009 he has focused on the Partner Development Infrastructure in the SAP Cloud organization as the responsible architect.

Preface and Acknowledgements
Introduction
Proactive Performance Management
Current Developments
About This Book
Performance Management of an SAP Solution
SAP Solution Architecture
Monitoring and Optimization Plan for an SAP Solution
Summary
Analysis of Hardware, Database, and ABAP Application Server
Basic Terms
Hardware Monitoring
Database Monitoring
Analyzing SAP Memory Configuration
Analyzing SAP Work Processes
Analysis of the Internet Communication Manager
Summary
Questions
Workload Analysis
Basics of Workload Analysis and Runtime Analysis
Workload Monitor
Workload Analysis
Performing Workload Analyses
Single-Record Statistics
End-to-End Workload Analysis
Summary
Questions
Hardware Sizing and Component Distribution
Initial Hardware Sizing
Sizing to Deal with Increased Workload, Change of Release, or Migration
Planning the System Landscape
Summary
Questions
Optimization of ABAP Programs
Performance Trace
Performance Analysis with ABAP Trace (Runtime Analysis)
Analyzing Memory Usage with ABAP Debugger and in the Memory Inspector
Code Inspector
Tips and Tricks for High-Performance ABAP Programs
Summary
Questions
Memory Management
Memory Management Fundamentals
Configuring and Monitoring Memory Areas
Summary
Questions
Load Distribution, Remote Function Calls, and SAP GUI
Services of SAP NetWeaver Application Server
Load Distribution within the ABAP Instances
Remote Function Calls
SAP Graphical User Interface
Summary
Questions
Internet Connection and SAP Fiori
SAP Web Applications
Analyses on the Presentation Server
Buffering of Web Documents
Performance Analysis of Web Applications on SAP NetWeaver AS ABAP
BSPs, Web Dynpro for ABAP, and Integrated ITS
SAP Fiori, SAPUI5, and OData Services
Conclusion
Questions
Optimizing Java Programs
Garbage Collection
Just-in-Time Compiler
SAP Management Console
SAP Java Virtual Machine Profiler
Memory Analyzer
Other Tools for Performance Analysis on the SAP NetWeaver AS Java
Summary
Questions
Locks
Lock Concepts of Database System and SAP System
Monitoring Locks
Number Range Buffering
Locking with Quantities and the Available-to-Promise Server
Summary
Questions
Optimizing SQL Statements
Identifying and Analyzing Expensive SQL Statements
Optimizing SQL Statements in Programs
Optimizing SQL Statements through Secondary Indexes
Summary
Questions
SAP Buffering
Table Buffering Fundamentals
Monitoring Table Buffering on the ABAP Server
Monitoring Object-Oriented Application Buffers
Summary
Questions
Optimizing Database Queries with SAP HANA
Basic Principles of the Main Memory Database in SAP HANA
Architecture of SAP HANA
Data Modeling from a Performance View
SAP HANA Administration Tools for Performance Optimization
Technical Optimization Options in Detail
Summary
Questions
Optimizing Queries in SAP Business Warehouse
Fundamentals of SAP Business Warehouse
SAP BW Administration Tools for Performance Optimization
Technical Optimization Options in Detail
Summary
Questions
Appendices
Database Monitors
Important Transaction Codes
Review Questions and Answers
Glossary
Information Sources
The Author
Index