Training Resources for:
ASE 15 Post-Migration Performance Tuning
Total 2 record(s) available.
ASE 15 Post-Migration Performance Tuning This course provides answers to the complexities experienced after migrating from ASE 12.5 or earlier databases to ASE 15. Diagnostic utilities will be explored to provide you with the knowledge and skills necessary to troubleshoot and tune migrated databases.
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
A Classroom course provided by Sybase USA in Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States
ASE 15 Post-Migration Performance TuningThis course provides answers to the complexities experienced after migrating from ASE 12.5 or earlier databases to ASE 15. Diagnostic utilities will be explored to provide you with the knowledge and skills necessary to troubleshoot and tune migrated databases.
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
A Classroom course provided by Sybase, Inc. in Ottawa, Toronto, Ontario, Canada
Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]
Tips:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.
|
|
|
