ASE 15 Migration for DBAs

Product type

ASE 15 Migration for DBAs

SAP Training
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.

Description

Goals

  • Determine changes that need to be made to the ASE 15.0.3 server
  • Understand optimization in ASE 15.0.x from the perspective of the * Database Administrator
  • Explain new optimization tools and their usage
  • Take advantage of new options to configure the Optimizer
  • Contribute to faster, more efficient code
  • Utilize MDA tables for monitoring server performance
  • Tune Procedure and Statement caches
  • Understand new tempdb functionalities
  • Make configuration changes that will improve your 15.0.3 server performance

Audience

  • Database Administrators
  • Sybase System Administrators
  • SQL Developers who want to understand changes in ASE 15.0.3 impacting their SQL development

Prerequisites

Essential
  • * Fast …

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.

Goals

  • Determine changes that need to be made to the ASE 15.0.3 server
  • Understand optimization in ASE 15.0.x from the perspective of the * Database Administrator
  • Explain new optimization tools and their usage
  • Take advantage of new options to configure the Optimizer
  • Contribute to faster, more efficient code
  • Utilize MDA tables for monitoring server performance
  • Tune Procedure and Statement caches
  • Understand new tempdb functionalities
  • Make configuration changes that will improve your 15.0.3 server performance

Audience

  • Database Administrators
  • Sybase System Administrators
  • SQL Developers who want to understand changes in ASE 15.0.3 impacting their SQL development

Prerequisites

Essential
  • * Fast Track to Adaptive Server Enterprise (EDB115) * System and Database Administration: Adaptive Server Enterprise (EDB356)

Content

  • New Functionalities in ASE 15.x
  • Database Changes
  • Configuration Parameter Changes
  • Access Methods for Queries and Data Modification
  • Costs and Benefits of Indexes
  • Query Optimizer
  • Statistics
  • Optimization
  • Joins and Join Types
  • Parallel Queries
  • Stored Procedure Compilation and Performance
  • New Index and Partitioning Behavior
  • Metrics, MDA Monitoring, and QPTune
  • Compatibility Mode

Notes

  • Explore the Adaptive Server Enterprise 15.0.3 server environment from a database administration perspective before and after a migration. Also, discover critical changes and enhanced functionalities that are now used governing server behavior. Take advantage of the monitoring and evaluation tools of Adaptive Server Enterprise 15; interpret their diagnoses into specific plans of action; and perform tasks to evaluate and modify the behavior of the optimizer to improve SQL code performance, so as to implement the most efficient data-change and data- retrieval T-SQL code in queries and stored procedures.
  • Understand how to more efficiently work with the statistics used by the new optimizer and make changes to existing methodologies for generating them. Understand and work with the MDA tables to more clearly understand, monitor and tune Procedure and Statement caches.

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.