ASE 15 Post-Migration Performance Tuning
- Type product
ASE 15 Post-Migration Performance Tuning
Opleiderscore:
Beschrijving
Goals
- 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:
-
- Application tracing
- sysquerymetrics
- Set Option Show
- Set statsplancosts
- MDA Tables
- Login Triggers
- QP Tune Utility
Audience
- Sybase ASE SQL Developers and DBAs
Prerequisites
Essential- * EDB366 - Powering Up with ASE 15, EDB634 - Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization, or equivalent work experience with ASE 15.
Content
- Introduction to ASE 15 Optimization
- State of ASE 15 After Upgrade
- Migration of ASE Databases and Required Post Mi…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Goals
- 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:
-
- Application tracing
- sysquerymetrics
- Set Option Show
- Set statsplancosts
- MDA Tables
- Login Triggers
- QP Tune Utility
Audience
- Sybase ASE SQL Developers and DBAs
Prerequisites
Essential- * EDB366 - Powering Up with ASE 15, EDB634 - Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization, or equivalent work experience with ASE 15.
Content
- 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
Notes
- 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.
Popular tags
No tags submitted for this course yet
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.