Looking to expand your SAP knowledge using trusted resources? Our Performance and Tuning: Configuring Adaptive Server Enterprise 15.7 (EDB553), latest book from SAP Learning Hub, is your key to mastering SAP systems and processes. Perfect for students, professionals, and SAP enthusiasts, this book provides verified content straight from the source.
Unit 1: Principles of Performance and Tuning
Lesson: Defining Performance and Tuning Principles
Lesson: Tuning with Benchmarks
Unit 2: Architectural Overview
Lesson: Outlining the Adaptive Server Architecture
Lesson: Describing the Task Execution Process in ASE
Unit 3: The Tuning Toolbox
Lesson: Operating External Applications
Lesson: Outlining the Session Options
Lesson: Analyzing Server Behavior with MDA Tables and QPM
Lesson: Monitoring System Procedures
Unit 4: Locking Principles
Lesson: Configuring a Locking Scheme
Lesson: Managing Contention
Unit 5: Fragmentation
Lesson: Identifying Fragmentation Causes and Prevention
Lesson: Diagnosing and Resolving Fragmentation
Unit 6: Multiple Engines
Lesson: Comparing the Process Kernel and Threaded Kernel
Lesson: Describing the Process Kernel
Lesson: Describing the Threaded Kernel
Lesson: Monitoring Spinlocks and Contention
Unit 7: Named Caches
Lesson: Analyzing Named Cache Concepts and Behavior
Lesson: Configuring Named Caches
Lesson: Configuring Large I/O
Lesson: Monitoring and Tuning Caches
Lesson: Configuring Metadata Caches
Unit 8: Specialty Cache Settings
Lesson: Changing the MRU - LRU rules
Lesson: Controlling Asynchronous Prefetch
Lesson: Using Cache Partitioning
Unit 9: Procedure Cache and Statement Cache Tuning
Lesson: Outlining Procedure Cache
Lesson: Utilizing Statement Cache
Unit 10: Device Usage
Lesson: Examining Database Space Usage
Lesson: Tuning and Troubleshooting I/O Issues
Lesson: Tuning Temporary Storage
Unit 11: Table Partitioning
Lesson: Partitioning Tables
Lesson: Identifying Performance Implications and Tuning
Unit 12: Optimizer Statistics
Lesson: Viewing Optimizer Statistics
Lesson: Creating, Updating, and Tuning Optimizer Statistics
Lesson: Upgrading from Prior Versions
Unit 13: Parallelism
Lesson: Outlining Parallelism Concepts and Syntax
Lesson: Monitoring Parallel Access
Lesson: Executing Parallel Sort
Unit 14: Logical Process Manager
Lesson: Configuring Execution Classes
Lesson: Binding Objects and Precedence
Lesson: Optimizing Performance Using the Logical Process Manager
Unit 15: The Bulk Copy Program (bcp)
Lesson: Tuning bcp for Improved Performance