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
Database Administrator
System Administrator
- Essential: EDB358 or equivalent experience
- Principles of Performance and Tuning
- Defining Performance and Tuning Principles
- Tuning with Benchmarks
- Architectural Overview
- Outlining the Adaptive Server Architecture
- Describing the Task Execution Process in ASE
- The Tuning Toolbox
- Principles of Performance and Tuning
- Defining Performance and Tuning Principles
- Tuning with Benchmarks
- Architectural Overview
- Outlining the Adaptive Server Architecture
- Describing the Task Execution Process in ASE
- The Tuning Toolbox
- Using client apps to characterize system performance
- Interpreting the output of set commands
- Analyzing Server Behavior with MDA Tables and QPM
- Using procedures to monitor the server
- Locking Principles
- Configuring a Locking Scheme
- Managing Contention
- Fragmentation
- Identifying Fragmentation Causes and Prevention
- Diagnosing and Resolving Fragmentation
- Multiple Engines
- Comparing the Process Kernel and Threaded Kernel
- Describing the Process Kernel
- Describing the Threaded Kernel
- Monitoring Spinlocks and Contention
- Named Caches
- Analyzing Named Cache Concepts and Behavior
- Configuring Named Caches
- Configuring Large I/O
- Monitoring and Tuning Caches
- Configuring Metadata Caches
- Specialty Cache Settings
- Changing the MRU - LRU rules
- Controlling Asynchronous Prefetch
- Using Cache Partitioning
- Procedure Cache and Statement Cache Tuning
- Outlining Procedure Cache
- Utilizing Statement Cache
- Device Usage
- Examining Database Space Usage
- Tuning and Troubleshooting I/O Issues
- Tuning Temporary Storage
- Table Partitioning
- Partitioning Tables
- Identifying Benefits of Partitioning
- Optimizer Statistics
- Viewing Optimizer Statistics
- Creating, Updating, and Tuning Optimizer Statistics
- Upgrading from Prior Versions
- Parallelism
- Outlining Parallelism Concepts and Syntax
- Monitoring Parallel Access
- Executing Parallel Sort
- Logical Process Manager
- Configuring Execution Classes
- Binding Objects and Precedence
- Optimizing Performance Using the Logical Process Manager
- The Bulk Copy Program (bcp)
- Tuning bcp for Improved Performance
Course based on software release: SAP ASE 15.7
Course notes and announcements:
1) Learn how to tune ASE database for optimal performance and explore ASE architecture in depth.
This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, and SAP Certified participant guides.
This 5 day instructor led course qualifies for 40 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com