Training Schedule Training Schedule

(EDB634) Performance & Tuning: (ASE) 16.0 Query Optimization
Code: EDB634 v15
Type: null
Tuition (USD): $3750
Length: 5 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 04/08/2019
Live Virtual, US 07/15/2019

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

Skills Gained:
Explain optimization tools and their use Discuss the steps involved in executing code from input to return of result set Use code to pass hints to the Optimizer Perform tasks to evaluate the behavior of the optimizer Implement the most efficient data-change and data-retrieval T-SQL code in your queries and stored procedures Force optimization steps on the Optimizer
Who Should Attend?
Developer Developer Consultant
Prerequisites:
  • Essential: EDB116 or equivalent knowledge
What You Will Learn:
  • Principles of Performance and Tuning
  • Defining Performance and Tuning Terms
  • Defining Tuning Methodology
  • Query Processing and Execution
  • Identifying the Client and Server Relationship
  • Defining the Query Scheduling Process
  • Defining the Optimization Process
  • The Tuning Toolbox
  • Using Diagnostic Tools for Tuning
  • Using Non-Session Tools for Tuning
  • Using Syntax Commands for Tuning
  • Table Structures
  • Identifying Table Structures
  • Partitioning Tables
  • Index Structures
  • Designing an Index
  • Creating Function-Based Indexes
  • Defining an Index Partitioning Strategy
  • Optimizer Statistics
  • Creating Optimizer Statistics
  • Examining Optimizer Statistics
  • Managing Optimizer Statistics
  • Tuning Statistic Maintenance
  • Query Optimization
  • Identifying the Phases of the Optimization Process
  • Controlling the Optimizer
  • Determining Compatibility Issues
  • Access Method Optimization
  • Optimizing Access Methods
  • Determining Query Strategies
  • Estimating the Costs of Queries
  • Joins
  • Analyzing Joins
  • Tuning Joins
  • Parallelism
  • Examining Parallel Query Plans
  • Configuring Parallelism
  • Examining Runtime Adjustments
  • Troubleshooting Parallelism Issues
  • Additional Optimization Techniques
  • Using Optimization Techniques
  • Defining Optimization Components
  • Optimizing Operators
  • Using Aggregate Processing
  • Data Modifications
  • Inserting Tables
  • Deleting Tables
  • Updating Tables and Indexes
  • Stored Procedure Optimization
  • Optimizing Stored Procedures
  • Troubleshooting Stored Procedure Issues
  • Costing Temporary Tables in Stored Procedures
  • Tuning Stored Procedures
  • Optimizer Statistics Tuning
  • Tuning Column Statistics
  • Creating Simulated Statistics
  • Abstract Plans
  • Defining Abstract Plans
  • Creating Abstract Plans
  • Tuning Abstract Plans
  • Performance Monitoring
  • Forcing the Optimizer
  • Monitoring Query Plan Performance
Course Info:
Course based on software release: SAP ASE 16.0

Course notes and announcements:

1) Learn how to measure the performance of T-SQL queries and tune your query development for the specific requirements of your business. Take advantage of the monitoring and evaluation ASE tools, and interpret their diagnoses into specific plans of action.

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.