Performance and Tuning: Configuring ASE 15.0 (ASE6)

Databases, SAP Sybase

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 apps to characterize system performance
    2. Interpreting the output of set commands
    3. Analyzing Server Behavior with MDA Tables and QPM
    4. Using procedures to monitor the server
  • Locking Principles
    1. Configuring a Locking Scheme
    2. Managing Contention
  • Fragmentation
    1. Identifying Fragmentation Causes 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. Analyzing 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 the MRU - LRU rules
    2. Controlling Asynchronous Prefetch
    3. Using Cache Partitioning
  • Procedure Cache and Statement Cache Tuning
    1. Outlining Procedure Cache
    2. Utilizing 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. dentifying Benefits of Partitioning
  • Optimizer Statistics
    1. Viewing Optimizer Statistics
    2. Creating, Updating, and Tuning Optimizer Statistics
    3. Upgrading 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 Precedence
    3. Optimizing Performance Using the Logical Process Manager
  • The Bulk Copy Program (bcp)
    1. Tuning bcp for Improved Performance
Schedule:
5 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: