Thomas Schneider
SAP Performance Optimization Guide
2 Angebote ab € 13,62 €
Thomas Schneider
SAP Performance Optimization Guide
- Gebundenes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Optimize the performance of your SAP system and run it efficiently - the new 5th edition of the SAP Performance Optimization Guide shows you how! Whether you re administering an R/3 system or one of SAP s latest solutions, in this book you will learn how to systematically identify and analyze a variety of performance issues, both from a technical and an application-related standpoint. In addition, this book will show you how to adapt the appropriate tuning measures, and how to verify their success. This new edition has been thoroughly revised and updated, focusing on the brand-new tools for…mehr
Optimize the performance of your SAP system and run it efficiently - the new 5th edition of the SAP Performance Optimization Guide shows you how! Whether you re administering an R/3 system or one of SAP s latest solutions, in this book you will learn how to systematically identify and analyze a variety of performance issues, both from a technical and an application-related standpoint. In addition, this book will show you how to adapt the appropriate tuning measures, and how to verify their success. This new edition has been thoroughly revised and updated, focusing on the brand-new tools for monitoring Java applications - especially end-to-end workload and runtime analysis with Solution Manager Diagnostics. In addition, analyzing Web Dynpro applications is covered in detail in this book.
Produktdetails
- Produktdetails
- SAP PRESS
- Verlag: Rheinwerk Verlag / SAP PRESS
- Artikelnr. des Verlages: 459/20368
- 6. Aufl.
- Seitenzahl: 798
- Erscheinungstermin: 21. August 2008
- Englisch
- Abmessung: 228mm x 175mm
- Gewicht: 1372g
- ISBN-13: 9781592293681
- ISBN-10: 1592293689
- Artikelnr.: 32056958
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
- SAP PRESS
- Verlag: Rheinwerk Verlag / SAP PRESS
- Artikelnr. des Verlages: 459/20368
- 6. Aufl.
- Seitenzahl: 798
- Erscheinungstermin: 21. August 2008
- Englisch
- Abmessung: 228mm x 175mm
- Gewicht: 1372g
- ISBN-13: 9781592293681
- ISBN-10: 1592293689
- Artikelnr.: 32056958
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
Schneider, Thomas§Dr. Thomas Schneider started his career at SAP in 1996. In the SAP Active Global Support team he was responsible for monitoring issues, performance analysis, and hardware sizing. In that position he also authored the bestseller "SAP Performance Optimization Guide". Since 2004 he has worked in the Research & Breakthrough Innovation group where he first was responsible for IT Service & Application Management, before focusing on the Partner Development Infrastructure at SAP Business ByDesign.
... Foreword ... 17
... Acknowledgments ... 19
... Introduction ... 21
1 ... Performance Management of an SAP Solution ... 33
... 1.1 ... SAP Solution Architecture ... 34
... 1.2 ... Monitoring and Optimization Plan for an SAP Solution ... 45
... 1.3 ... Summary ... 69
2 ... Monitoring Hardware, Databases, and SAP Basis ... 73
... 2.1 ... Basic Terms ... 74
... 2.2 ... Hardware Monitoring ... 75
... 2.3 ... Database Monitoring ... 87
... 2.4 ... Analyzing SAP Memory Configuration ... 109
... 2.5 ... Analyzing SAP Work Processes ... 118
... 2.6 ... Analyzing Java Virtual Machine (JVM) Memory Management and Work Processes ... 129
... 2.7 ... Analysis of the Internet Communication Manager (ICM) ... 138
... 2.8 ... Continuous Monitoring Using CCMS ... 139
... 2.9 ... Summary ... 148
3 ... Workload Analysis ... 151
... 3.1 ... Basics of Workload Analysis and Runtime Analysis ... 152
... 3.2 ... Workload Monitor ... 157
... 3.3 ... Workload Analysis ... 161
... 3.4 ... Performing Workload Analyses ... 169
... 3.5 ... Application Monitor ... 181
... 3.6 ... Central Workload Monitor ... 184
... 3.7 ... The Java Workload Monitor in SAP Solution Manager and the Introscope Monitor ... 189
... 3.8 ... Performing Workload Analysis for the SAP J2EE Engine ... 194
... 3.9 ... Summary ... 197
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) ... 221
... 4.5 ... Analyzing Memory Usage with ABAP Debugger and in the Memory Inspector ... 230
... 4.6 ... Code Inspector ... 234
... 4.7 ... Introscope Trace ... 236
... 4.8 ... End-to-End Runtime Analysis in SAP Solution Manager ... 238
... 4.9 ... Summary ... 242
5 ... Hardware Sizing and System Distribution ... 247
... 5.1 ... Initial Hardware Sizing ... 248
... 5.2 ... Sizing to Deal with Increased Workload, Change of Release, or Migration ... 263
... 5.3 ... Planning the System Landscape ... 272
... 5.4 ... Summary ... 278
6 ... Workload Distribution and Interfaces ... 281
... 6.1 ... Services of the SAP NetWeaver Application Server ... 282
... 6.2 ... Load Distribution Within the ABAP Application Instances ... 288
... 6.3 ... Remote Function Calls (RFCs) ... 306
... 6.4 ... SAP Virtual Machine Container ... 322
... 6.5 ... Summary ... 324
7 ... SAP GUI and Internet Connection ... 329
... 7.1 ... SAP GUI ... 329
... 7.2 ... SAP NetWeaver Application Server ... 338
... 7.3 ... Analyses on the Presentation Server ... 342
... 7.4 ... Internet Transaction Server ... 348
... 7.5 ... Business Server Pages (BSPs), Web Dynpro for ABAP, and Integrated ITS ... 357
... 7.6 ... JavaServer Pages and Web Dynpro for Java ... 367
... 7.7 ... Summary ... 370
8 ... Memory Management ... 375
... 8.1 ... Memory Management Fundamentals ... 375
... 8.2 ... Configuring and Monitoring SAP Memory Areas ... 389
... 8.3 ... Summary ... 409
9 ... SAP Buffering ... 413
... 9.1 ... Preliminary Remarks Concerning Chapters 9, 10, and 11 ... 415
... 9.2 ... Table Buffering Fundamentals ... 416
... 9.3 ... Monitoring Table Buffering on the ABAP Server ... 428
... 9.4 ... Monitoring the Table Buffering on the SAP J2EE Engine ... 444
... 9.5 ... Monitoring Object-Oriented Application Buffers ... 447
... 9.6 ... Summary ... 452
10 ... Locks ... 455
... 10.1 ... Database Locks and SAP Enqueues ... 455
... 10.2 ... Monitoring Locks ... 459
... 10.3 ... Number Range Buffering ... 465
... 10.4 ... ATP Server ... 471
... 10.5 ... Summary ... 477
11 ... Optimizing SQL Statements ... 479
... 11.1 ... Identifying and Analyzing Expensive SQL Statements ... 480
... 11.2 ... Optimizing SQL Statements Through Secondary Indexes ... 487
... 11.3 ... Optimizing SQL Statements in the ABAP Program ... 514
... 11.4 ... Expensive SQL Statements Due to Incorrect Buffer Settings and Administration Tools ... 534
... 11.5 ... Summary ... 536
12 ... Optimizing Queries to SAP NetWeaver Business Warehouse ... 541
... 12.1 ... Fundamentals of SAP NetWeaver Business Warehouse ... 542
... 12.2 ... Analysis of Expensive BW Queries ... 560
... 12.3 ... Technical Optimization Options in Detail ... 566
... 12.4 ... Summary ... 592
13 ... Optimizing Search Queries Using TREX ... 595
... 13.1 ... Fundamentals and Architecture of TREX Considering Performance Aspects ... 596
... 13.2 ... Implementing the Performance Analysis on TREX ... 609
... 13.3 ... Technical Optimization Options in Detail ... 616
... 13.4 ... Indexing InfoCubes in SAP NetWeaver BW Accelerator ... 629
... 13.5 ... Summary ... 634
... Appendices ... 639
... A ... Performance Analysis Roadmaps and Checklists ... 641
... B ... Database Monitors, Buffers, and SQL Execution Plans ... 663
... C ... Performance-Relevant Configuration Parameters and Key Figures ... 715
... D ... Selected Transaction Codes ... 737
... E ... Review Questions and Answers ... 741
... F ... Glossary ... 757
... G ... Information Sources ... 767
... Index ... 781
... Acknowledgments ... 19
... Introduction ... 21
1 ... Performance Management of an SAP Solution ... 33
... 1.1 ... SAP Solution Architecture ... 34
... 1.2 ... Monitoring and Optimization Plan for an SAP Solution ... 45
... 1.3 ... Summary ... 69
2 ... Monitoring Hardware, Databases, and SAP Basis ... 73
... 2.1 ... Basic Terms ... 74
... 2.2 ... Hardware Monitoring ... 75
... 2.3 ... Database Monitoring ... 87
... 2.4 ... Analyzing SAP Memory Configuration ... 109
... 2.5 ... Analyzing SAP Work Processes ... 118
... 2.6 ... Analyzing Java Virtual Machine (JVM) Memory Management and Work Processes ... 129
... 2.7 ... Analysis of the Internet Communication Manager (ICM) ... 138
... 2.8 ... Continuous Monitoring Using CCMS ... 139
... 2.9 ... Summary ... 148
3 ... Workload Analysis ... 151
... 3.1 ... Basics of Workload Analysis and Runtime Analysis ... 152
... 3.2 ... Workload Monitor ... 157
... 3.3 ... Workload Analysis ... 161
... 3.4 ... Performing Workload Analyses ... 169
... 3.5 ... Application Monitor ... 181
... 3.6 ... Central Workload Monitor ... 184
... 3.7 ... The Java Workload Monitor in SAP Solution Manager and the Introscope Monitor ... 189
... 3.8 ... Performing Workload Analysis for the SAP J2EE Engine ... 194
... 3.9 ... Summary ... 197
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) ... 221
... 4.5 ... Analyzing Memory Usage with ABAP Debugger and in the Memory Inspector ... 230
... 4.6 ... Code Inspector ... 234
... 4.7 ... Introscope Trace ... 236
... 4.8 ... End-to-End Runtime Analysis in SAP Solution Manager ... 238
... 4.9 ... Summary ... 242
5 ... Hardware Sizing and System Distribution ... 247
... 5.1 ... Initial Hardware Sizing ... 248
... 5.2 ... Sizing to Deal with Increased Workload, Change of Release, or Migration ... 263
... 5.3 ... Planning the System Landscape ... 272
... 5.4 ... Summary ... 278
6 ... Workload Distribution and Interfaces ... 281
... 6.1 ... Services of the SAP NetWeaver Application Server ... 282
... 6.2 ... Load Distribution Within the ABAP Application Instances ... 288
... 6.3 ... Remote Function Calls (RFCs) ... 306
... 6.4 ... SAP Virtual Machine Container ... 322
... 6.5 ... Summary ... 324
7 ... SAP GUI and Internet Connection ... 329
... 7.1 ... SAP GUI ... 329
... 7.2 ... SAP NetWeaver Application Server ... 338
... 7.3 ... Analyses on the Presentation Server ... 342
... 7.4 ... Internet Transaction Server ... 348
... 7.5 ... Business Server Pages (BSPs), Web Dynpro for ABAP, and Integrated ITS ... 357
... 7.6 ... JavaServer Pages and Web Dynpro for Java ... 367
... 7.7 ... Summary ... 370
8 ... Memory Management ... 375
... 8.1 ... Memory Management Fundamentals ... 375
... 8.2 ... Configuring and Monitoring SAP Memory Areas ... 389
... 8.3 ... Summary ... 409
9 ... SAP Buffering ... 413
... 9.1 ... Preliminary Remarks Concerning Chapters 9, 10, and 11 ... 415
... 9.2 ... Table Buffering Fundamentals ... 416
... 9.3 ... Monitoring Table Buffering on the ABAP Server ... 428
... 9.4 ... Monitoring the Table Buffering on the SAP J2EE Engine ... 444
... 9.5 ... Monitoring Object-Oriented Application Buffers ... 447
... 9.6 ... Summary ... 452
10 ... Locks ... 455
... 10.1 ... Database Locks and SAP Enqueues ... 455
... 10.2 ... Monitoring Locks ... 459
... 10.3 ... Number Range Buffering ... 465
... 10.4 ... ATP Server ... 471
... 10.5 ... Summary ... 477
11 ... Optimizing SQL Statements ... 479
... 11.1 ... Identifying and Analyzing Expensive SQL Statements ... 480
... 11.2 ... Optimizing SQL Statements Through Secondary Indexes ... 487
... 11.3 ... Optimizing SQL Statements in the ABAP Program ... 514
... 11.4 ... Expensive SQL Statements Due to Incorrect Buffer Settings and Administration Tools ... 534
... 11.5 ... Summary ... 536
12 ... Optimizing Queries to SAP NetWeaver Business Warehouse ... 541
... 12.1 ... Fundamentals of SAP NetWeaver Business Warehouse ... 542
... 12.2 ... Analysis of Expensive BW Queries ... 560
... 12.3 ... Technical Optimization Options in Detail ... 566
... 12.4 ... Summary ... 592
13 ... Optimizing Search Queries Using TREX ... 595
... 13.1 ... Fundamentals and Architecture of TREX Considering Performance Aspects ... 596
... 13.2 ... Implementing the Performance Analysis on TREX ... 609
... 13.3 ... Technical Optimization Options in Detail ... 616
... 13.4 ... Indexing InfoCubes in SAP NetWeaver BW Accelerator ... 629
... 13.5 ... Summary ... 634
... Appendices ... 639
... A ... Performance Analysis Roadmaps and Checklists ... 641
... B ... Database Monitors, Buffers, and SQL Execution Plans ... 663
... C ... Performance-Relevant Configuration Parameters and Key Figures ... 715
... D ... Selected Transaction Codes ... 737
... E ... Review Questions and Answers ... 741
... F ... Glossary ... 757
... G ... Information Sources ... 767
... Index ... 781
... Foreword ... 17
... Acknowledgments ... 19
... Introduction ... 21
1 ... Performance Management of an SAP Solution ... 33
... 1.1 ... SAP Solution Architecture ... 34
... 1.2 ... Monitoring and Optimization Plan for an SAP Solution ... 45
... 1.3 ... Summary ... 69
2 ... Monitoring Hardware, Databases, and SAP Basis ... 73
... 2.1 ... Basic Terms ... 74
... 2.2 ... Hardware Monitoring ... 75
... 2.3 ... Database Monitoring ... 87
... 2.4 ... Analyzing SAP Memory Configuration ... 109
... 2.5 ... Analyzing SAP Work Processes ... 118
... 2.6 ... Analyzing Java Virtual Machine (JVM) Memory Management and Work Processes ... 129
... 2.7 ... Analysis of the Internet Communication Manager (ICM) ... 138
... 2.8 ... Continuous Monitoring Using CCMS ... 139
... 2.9 ... Summary ... 148
3 ... Workload Analysis ... 151
... 3.1 ... Basics of Workload Analysis and Runtime Analysis ... 152
... 3.2 ... Workload Monitor ... 157
... 3.3 ... Workload Analysis ... 161
... 3.4 ... Performing Workload Analyses ... 169
... 3.5 ... Application Monitor ... 181
... 3.6 ... Central Workload Monitor ... 184
... 3.7 ... The Java Workload Monitor in SAP Solution Manager and the Introscope Monitor ... 189
... 3.8 ... Performing Workload Analysis for the SAP J2EE Engine ... 194
... 3.9 ... Summary ... 197
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) ... 221
... 4.5 ... Analyzing Memory Usage with ABAP Debugger and in the Memory Inspector ... 230
... 4.6 ... Code Inspector ... 234
... 4.7 ... Introscope Trace ... 236
... 4.8 ... End-to-End Runtime Analysis in SAP Solution Manager ... 238
... 4.9 ... Summary ... 242
5 ... Hardware Sizing and System Distribution ... 247
... 5.1 ... Initial Hardware Sizing ... 248
... 5.2 ... Sizing to Deal with Increased Workload, Change of Release, or Migration ... 263
... 5.3 ... Planning the System Landscape ... 272
... 5.4 ... Summary ... 278
6 ... Workload Distribution and Interfaces ... 281
... 6.1 ... Services of the SAP NetWeaver Application Server ... 282
... 6.2 ... Load Distribution Within the ABAP Application Instances ... 288
... 6.3 ... Remote Function Calls (RFCs) ... 306
... 6.4 ... SAP Virtual Machine Container ... 322
... 6.5 ... Summary ... 324
7 ... SAP GUI and Internet Connection ... 329
... 7.1 ... SAP GUI ... 329
... 7.2 ... SAP NetWeaver Application Server ... 338
... 7.3 ... Analyses on the Presentation Server ... 342
... 7.4 ... Internet Transaction Server ... 348
... 7.5 ... Business Server Pages (BSPs), Web Dynpro for ABAP, and Integrated ITS ... 357
... 7.6 ... JavaServer Pages and Web Dynpro for Java ... 367
... 7.7 ... Summary ... 370
8 ... Memory Management ... 375
... 8.1 ... Memory Management Fundamentals ... 375
... 8.2 ... Configuring and Monitoring SAP Memory Areas ... 389
... 8.3 ... Summary ... 409
9 ... SAP Buffering ... 413
... 9.1 ... Preliminary Remarks Concerning Chapters 9, 10, and 11 ... 415
... 9.2 ... Table Buffering Fundamentals ... 416
... 9.3 ... Monitoring Table Buffering on the ABAP Server ... 428
... 9.4 ... Monitoring the Table Buffering on the SAP J2EE Engine ... 444
... 9.5 ... Monitoring Object-Oriented Application Buffers ... 447
... 9.6 ... Summary ... 452
10 ... Locks ... 455
... 10.1 ... Database Locks and SAP Enqueues ... 455
... 10.2 ... Monitoring Locks ... 459
... 10.3 ... Number Range Buffering ... 465
... 10.4 ... ATP Server ... 471
... 10.5 ... Summary ... 477
11 ... Optimizing SQL Statements ... 479
... 11.1 ... Identifying and Analyzing Expensive SQL Statements ... 480
... 11.2 ... Optimizing SQL Statements Through Secondary Indexes ... 487
... 11.3 ... Optimizing SQL Statements in the ABAP Program ... 514
... 11.4 ... Expensive SQL Statements Due to Incorrect Buffer Settings and Administration Tools ... 534
... 11.5 ... Summary ... 536
12 ... Optimizing Queries to SAP NetWeaver Business Warehouse ... 541
... 12.1 ... Fundamentals of SAP NetWeaver Business Warehouse ... 542
... 12.2 ... Analysis of Expensive BW Queries ... 560
... 12.3 ... Technical Optimization Options in Detail ... 566
... 12.4 ... Summary ... 592
13 ... Optimizing Search Queries Using TREX ... 595
... 13.1 ... Fundamentals and Architecture of TREX Considering Performance Aspects ... 596
... 13.2 ... Implementing the Performance Analysis on TREX ... 609
... 13.3 ... Technical Optimization Options in Detail ... 616
... 13.4 ... Indexing InfoCubes in SAP NetWeaver BW Accelerator ... 629
... 13.5 ... Summary ... 634
... Appendices ... 639
... A ... Performance Analysis Roadmaps and Checklists ... 641
... B ... Database Monitors, Buffers, and SQL Execution Plans ... 663
... C ... Performance-Relevant Configuration Parameters and Key Figures ... 715
... D ... Selected Transaction Codes ... 737
... E ... Review Questions and Answers ... 741
... F ... Glossary ... 757
... G ... Information Sources ... 767
... Index ... 781
... Acknowledgments ... 19
... Introduction ... 21
1 ... Performance Management of an SAP Solution ... 33
... 1.1 ... SAP Solution Architecture ... 34
... 1.2 ... Monitoring and Optimization Plan for an SAP Solution ... 45
... 1.3 ... Summary ... 69
2 ... Monitoring Hardware, Databases, and SAP Basis ... 73
... 2.1 ... Basic Terms ... 74
... 2.2 ... Hardware Monitoring ... 75
... 2.3 ... Database Monitoring ... 87
... 2.4 ... Analyzing SAP Memory Configuration ... 109
... 2.5 ... Analyzing SAP Work Processes ... 118
... 2.6 ... Analyzing Java Virtual Machine (JVM) Memory Management and Work Processes ... 129
... 2.7 ... Analysis of the Internet Communication Manager (ICM) ... 138
... 2.8 ... Continuous Monitoring Using CCMS ... 139
... 2.9 ... Summary ... 148
3 ... Workload Analysis ... 151
... 3.1 ... Basics of Workload Analysis and Runtime Analysis ... 152
... 3.2 ... Workload Monitor ... 157
... 3.3 ... Workload Analysis ... 161
... 3.4 ... Performing Workload Analyses ... 169
... 3.5 ... Application Monitor ... 181
... 3.6 ... Central Workload Monitor ... 184
... 3.7 ... The Java Workload Monitor in SAP Solution Manager and the Introscope Monitor ... 189
... 3.8 ... Performing Workload Analysis for the SAP J2EE Engine ... 194
... 3.9 ... Summary ... 197
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) ... 221
... 4.5 ... Analyzing Memory Usage with ABAP Debugger and in the Memory Inspector ... 230
... 4.6 ... Code Inspector ... 234
... 4.7 ... Introscope Trace ... 236
... 4.8 ... End-to-End Runtime Analysis in SAP Solution Manager ... 238
... 4.9 ... Summary ... 242
5 ... Hardware Sizing and System Distribution ... 247
... 5.1 ... Initial Hardware Sizing ... 248
... 5.2 ... Sizing to Deal with Increased Workload, Change of Release, or Migration ... 263
... 5.3 ... Planning the System Landscape ... 272
... 5.4 ... Summary ... 278
6 ... Workload Distribution and Interfaces ... 281
... 6.1 ... Services of the SAP NetWeaver Application Server ... 282
... 6.2 ... Load Distribution Within the ABAP Application Instances ... 288
... 6.3 ... Remote Function Calls (RFCs) ... 306
... 6.4 ... SAP Virtual Machine Container ... 322
... 6.5 ... Summary ... 324
7 ... SAP GUI and Internet Connection ... 329
... 7.1 ... SAP GUI ... 329
... 7.2 ... SAP NetWeaver Application Server ... 338
... 7.3 ... Analyses on the Presentation Server ... 342
... 7.4 ... Internet Transaction Server ... 348
... 7.5 ... Business Server Pages (BSPs), Web Dynpro for ABAP, and Integrated ITS ... 357
... 7.6 ... JavaServer Pages and Web Dynpro for Java ... 367
... 7.7 ... Summary ... 370
8 ... Memory Management ... 375
... 8.1 ... Memory Management Fundamentals ... 375
... 8.2 ... Configuring and Monitoring SAP Memory Areas ... 389
... 8.3 ... Summary ... 409
9 ... SAP Buffering ... 413
... 9.1 ... Preliminary Remarks Concerning Chapters 9, 10, and 11 ... 415
... 9.2 ... Table Buffering Fundamentals ... 416
... 9.3 ... Monitoring Table Buffering on the ABAP Server ... 428
... 9.4 ... Monitoring the Table Buffering on the SAP J2EE Engine ... 444
... 9.5 ... Monitoring Object-Oriented Application Buffers ... 447
... 9.6 ... Summary ... 452
10 ... Locks ... 455
... 10.1 ... Database Locks and SAP Enqueues ... 455
... 10.2 ... Monitoring Locks ... 459
... 10.3 ... Number Range Buffering ... 465
... 10.4 ... ATP Server ... 471
... 10.5 ... Summary ... 477
11 ... Optimizing SQL Statements ... 479
... 11.1 ... Identifying and Analyzing Expensive SQL Statements ... 480
... 11.2 ... Optimizing SQL Statements Through Secondary Indexes ... 487
... 11.3 ... Optimizing SQL Statements in the ABAP Program ... 514
... 11.4 ... Expensive SQL Statements Due to Incorrect Buffer Settings and Administration Tools ... 534
... 11.5 ... Summary ... 536
12 ... Optimizing Queries to SAP NetWeaver Business Warehouse ... 541
... 12.1 ... Fundamentals of SAP NetWeaver Business Warehouse ... 542
... 12.2 ... Analysis of Expensive BW Queries ... 560
... 12.3 ... Technical Optimization Options in Detail ... 566
... 12.4 ... Summary ... 592
13 ... Optimizing Search Queries Using TREX ... 595
... 13.1 ... Fundamentals and Architecture of TREX Considering Performance Aspects ... 596
... 13.2 ... Implementing the Performance Analysis on TREX ... 609
... 13.3 ... Technical Optimization Options in Detail ... 616
... 13.4 ... Indexing InfoCubes in SAP NetWeaver BW Accelerator ... 629
... 13.5 ... Summary ... 634
... Appendices ... 639
... A ... Performance Analysis Roadmaps and Checklists ... 641
... B ... Database Monitors, Buffers, and SQL Execution Plans ... 663
... C ... Performance-Relevant Configuration Parameters and Key Figures ... 715
... D ... Selected Transaction Codes ... 737
... E ... Review Questions and Answers ... 741
... F ... Glossary ... 757
... G ... Information Sources ... 767
... Index ... 781