ASE 15 Post-Migration Performance Tuning

Product type
E-learning

ASE 15 Post-Migration Performance Tuning

$1,636.36warning
  • VAT: excluding VAT
  • Price completeness: There could be additional costs like study material or lunch costs.
/E-learning
SAP Training
Get alternatives
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Get alternatives
Description

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Lean, Building / Construction, Project Management, Planning, and Six Sigma.

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

There are no reviews yet.
    Share your review
    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.