Chapter 8. SAP BW performance 271
8.4.1 Performance bottlenecks
In an SAP BW system there is a high level of interdependency between any
system bottlenecks and long-running transactions or programs.
The cause of
system bottlenecks could be:
Lack of hardware resources, such as:
–CPU
– Real and virtual memory
– Disk- devices, caches, controller, and access paths, resulting in poor
Input/output operations (I/O waits)
Poor configuration of:
–Memory
–SAP buffers
– Workprocess distribution
The cause of
long running programs could be:
Unnecessary functionality
Inefficient implementation of technology, such as:
– Database table buffering
– Database indexes
– ABAP coding (inefficient SQL)
lack of experience regarding the implementation
–Customizing
– Sub-opt ...