Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

Performance and Tuning: Configuring Adaptive Server Enterprise 15.7

  • Tuition USD $4,090 GSA  $3,037.78
  • Reviews star_rate star_rate star_rate star_rate star_half 1527 Ratings
  • Course Code EDB553-v010
  • Duration 5 days
  • Available Formats Virtual, Classroom

Prerequisites

EDB358 or equivalent experience

Course Details

Principles of Performance and Tuning

  • Defining Performance and Tuning Principles
  • Tuning with Benchmarks

Architectural Overview

  • Outlining the Adaptive Server Architecture
  • Describing the Task Execution Process in ASE

The Tuning Toolbox

  • Using client apps to characterize system performance
  • Interpreting the output of set commands
  • Analyzing Server Behavior with MDA Tables and QPM
  • Using procedures to monitor the server

Locking Principles

  • Configuring a Locking Scheme
  • Managing Contention

Fragmentation

  • Identifying Fragmentation Causes and Prevention
  • Diagnosing and Resolving Fragmentation

Multiple Engines

  • Comparing the Process Kernel and Threaded Kernel
  • Describing the Process Kernel
  • Describing the Threaded Kernel
  • Monitoring Spinlocks and Contention

Named Caches

  • Analyzing Named Cache Concepts and Behavior
  • Configuring Named Caches
  • Configuring Large I/O
  • Monitoring and Tuning Caches
  • Configuring Metadata Caches

Specialty Cache Settings

  • Changing the MRU - LRU rules
  • Controlling Asynchronous Prefetch
  • Using Cache Partitioning

Procedure Cache and Statement Cache Tuning

  • Outlining Procedure Cache
  • Utilizing Statement Cache

Device Usage

  • Examining Database Space Usage
  • Tuning and Troubleshooting I/O Issues
  • Tuning Temporary Storage

Table Partitioning

  • Partitioning Tables
  • Identifying Benefits of Partitioning

Optimizer Statistics

  • Viewing Optimizer Statistics
  • Creating, Updating, and Tuning Optimizer Statistics
  • Upgrading from Prior Versions

Parallelism

  • Outlining Parallelism Concepts and Syntax
  • Monitoring Parallel Access
  • Executing Parallel Sort

Logical Process Manager

  • Configuring Execution Classes
  • Binding Objects and Precedence
  • Optimizing Performance Using the Logical Process Manager

The Bulk Copy Program (bcp)

  • Tuning bcp for Improved Performance

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Excellent course. Ruben Lopez is an outstanding instructor. Learned tons of information. Would recommend ExitCertified to anyone!

Great training that provided pro-tips a plenty that were immediately put to use.

Both course material and instructor demonstrated a sound foundation on Maximo material

There were minimal errors. The labs were great but the learning environment was difficult to navigate and certain components needed to stay on the screen that covered up parts of the presentation slides.

Tech Data helped in gaining more information on the latest version of IIB.
Architectural changes, migration and administration.

Kudos to Manish, for driving session in interactive and productive manner.

2 options available

undo
  • Mar 22, 2021 Mar 26, 2021 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Sep 27, 2021 Oct 1, 2021 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward