SAP Performance and Tuning: Configuring Adaptive Server Enterprise 15.7

PT20523
Training Summary
Skills gained from this class include:
  • Discuss tradeoffs involved in performance tuning
  • Use sp_sysmon and other utilities to tune the server for performance gains
  • Properly configure memory for optimal performance
  • Manage multiple engines
  • Configure, tune, and size data, procedure, and partitioned caches
  • Identify and correct problems in database physical design, including table partitions
  • Use statistics to manage space on DOL tables and indexes
  • Choose the appropriate table locking scheme for a given application
  • Reconfigure Adaptive Server dynamically
  • Improve performance of tempdb by sizing, placement, and solving locking
Prerequisites
Before taking this course, students must have taken the System and Database Administration: Adaptive Server Enterprise course or have equivalent experience.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for database administrators and system administrators.
Course Topics
Principles of Performance and Tuning
  • Architectural Overview
  • The Tuning Toolbox
  • Locking Principles
  • Fragmentation
  • Multiple Engines
  • Named Caches
  • Specialty Cache Settings
  • Procedure Cache and Statement Cache Tuning
  • Device Usage
  • Table Partitioning
  • Optimizer Statistics
  • Parallelism
  • Logical Process Manager
  • The Bulk Copy Program (bcp)

Related Scheduled Courses