Course Objectives:
Upon completion of this course, you will be able to:
- Understand and diagnose statistics-related problems
- Assess and modify configuration to ensure the Optimizer makes the right choices
- Use appropriate diagnostic tools to trouble-shoot issues, including these tools:
o Application tracing
o sysquerymetrics
o Set Option Show
o Set statsplancosts
o MDA Tables
o Login Triggers
o QP Tune Utility
Course Topics:
- Introduction to ASE 15 Optimization
- State of ASE 15 After Upgrade
- Migration of ASE Databases and Required Post Migration Tasks
- Tools for Finding Query Problems
- Diagnostic Methods
- Query Optimization Control Methods
- QPTune & Other Tools
Who Should Attend: Sybase ASE SQL Developers and DBAs
Prerequisites:
EDB366 - Powering Up with ASE 15, EDB634 - Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization, or equivalent work experience with ASE 15.
Skill: Expert
Format:
100% Lecture
Type:
SyberLearning OnDemand
Duration: 3 days
Delivery Times:
SyberLearning OnDemand (Instructor-recorded, self-paced training): 3 DAYS CONTENT
|
