Performance and Tuning: Configuring Adaptive Server Enterprise 15.7 (ASE6)

This course explains what affects Adaptive Server Enterprise 15.7 performance and the applications that use it. It focuses on server architecture, how database design affects speed, and practical resource management for CPU, disk and I/O to stabilize system behavior.

The course covers parallel query processing, parallel sort, and SMP extensions including the Logical Process Manager. It also shows how to define performance baselines and apply proven troubleshooting methodologies to speed up tuning.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Principles of Performance and Tuning
    1. Defining performance and tuning principles
    2. Tuning with benchmarks
  • Architectural Overview
    1. Outlining the Adaptive Server architecture
    2. Describing the task execution process in ASE
  • The Tuning Toolbox
    1. Using client applications to profile system performance
    2. Interpreting the output of set commands
    3. Analyzing server behavior with MDA tables and QPM
    4. Using stored procedures to monitor the server
  • Locking Principles
    1. Configuring a locking scheme
    2. Managing contention
  • Fragmentation
    1. Identifying causes of fragmentation and prevention
    2. Diagnosing and resolving fragmentation
  • Multiple Engines
    1. Comparing the process kernel and threaded kernel
    2. Describing the process kernel
    3. Describing the threaded kernel
    4. Monitoring spinlocks and contention
  • Named Caches
    1. Explaining named cache concepts and behavior
    2. Configuring named caches
    3. Configuring large I/O
    4. Monitoring and tuning caches
    5. Configuring metadata caches
  • Specialty Cache Settings
    1. Changing MRU/LRU rules
    2. Controlling asynchronous prefetch
    3. Using cache partitioning
  • Procedure Cache and Statement Cache Tuning
    1. Outlining the procedure cache
    2. Using the statement cache
  • Device Usage
    1. Examining database space usage
    2. Tuning and troubleshooting I/O issues
    3. Tuning temporary storage
  • Table Partitioning
    1. Partitioning tables
    2. Identifying benefits of partitioning
  • Optimizer Statistics
    1. Viewing optimizer statistics
    2. Creating, updating, and tuning optimizer statistics
    3. Upgrading statistics from prior versions
  • Parallelism
    1. Outlining parallelism concepts and syntax
    2. Monitoring parallel access
    3. Executing parallel sort
  • Logical Process Manager
    1. Configuring execution classes
    2. Binding objects and setting precedence
    3. Optimizing performance with the Logical Process Manager
  • The Bulk Copy Program (bcp)
    1. Tuning bcp for improved performance
Assumed knowledge:
Completion of Fast Track to ASE and System and Database Administration ASE courses, or equivalent experience.
Schedule:
5 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: