Training Schedule Training Schedule

(EDB553) Performance and Tuning: Configuring (ASE) 15.7
Code: EDB553 v10
Type: null
Tuition (USD): $3750
Length: 5 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 10/21/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

Skills Gained:
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
Who Should Attend?
Database Administrator System Administrator
Prerequisites:
  • Essential: EDB358 or equivalent experience
What You Will Learn:
  • 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 Info:
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, SAP Certified e-book participant guides and SAP Certified Hard copy 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.