MaxDB Performance Monitoring and Optimization

Goals

• • Enable the course participants to detect, analyze and resolve performance relevant issues in an SAP MaxDB database management system

Audience

• • Experienced SAP MaxDB database system administrators and consultants • Project members responsible for SAP MaxDB performance issues

Prerequisites

• • Successful completion of course ADM515 MaxDB database administration • An SAP R/3 or SAP NetWeaver user with full administrator authorizations in an R/3 or NetWeaver system (Optional, an open connection to the SAPNet - R/3 Frontend (former OSS) can be used by the trainer to contact the customer living system to present an system analysis in the classroom, while the course is in progress. But an individual access for every participant to his own production system via an existing Wireless LAN solution, would be much more appreciated) • SAP Release 4.6C or higher

Content

• • Basics in SAP MaxDB Architecture • Monitoring SAP MaxDB contribution to general performance • Detecting database intensive SAP transactions • Using DB50 or DBACOCKPIT to monitor SAP MaxDB components such as data cache, volumes, locks • Using SAP MaxDB Database Analyzer (Bottleneck Analysis) • Monitoring expensive SQL statements: Command and Resource Monitor • Concepts of cost based optimizer • Secondary index design • Optimizing expensive SQL statements • Performance analysis roadmap

Notes

• • Very important: Access to an living SAP system (>= 4.6C) is required to complete the exercises successfully • The course participant must ensure that he is able to connect from external network locations to his customer SAP system. Wireless LAN is offered in the training room with access to the public Internet (access data is offered during the class). The participant should use his own notebook to connect through secured channels to the customer SAP system via the wireless LAN and the public Internet in between. • There will be no test or demo systems available for this training. Instead we will analyze the living customer systems directly. • For optimal results, this course is limited to 10-15 participants. • The course material is only available in English

Popular tags

No tags submitted for this course yet