| Course Code: |
RT 134 |
| Course Abstract: |
This course teaches database administrators how to tune an Adaptive Server for optimal performance. It explores Adaptive Server architecture in depth, and includes sections on designing databases for performance, managing Adaptive Server system resources (CPUs, disks, I/O), choosing appropriate locking schemes, optimizer statistics, SMP features, relevant data structures, and parallel processing. |
| Audience: |
This course is designed for Database Administrators, Open Interface Developers, and Application Developers. |
| Duration: |
5 days |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
>Discuss tradeoffs involved in performance tuning
>Use Sybase utilities to optimize performance
>Identify and correct problems in database physical design
>Properly configure memory and choose appropriate cache strategies
>Enable parallel queries and correctly configure parallel sort parameters
>Manage multiple engines
>Choose the appropriate locking scheme for a given application
>Manage space issues related to locking schemes
>Configure lock promotion |
| Course Topics: |
Tuning transaction processing for OLTP, DSS, and batch applications
Benchmarking techniques
Optimizing hardware device usage and space management
Choosing locking schemes
Configuring lock promotion at server, database, and object levels
Working with multiple engines in the SMP environment
Data cache configuration and tuning, and cache partitioning
Procedure cache configuration and tuning
Working with tempdb
Optimizer statistics
Working with parallel queries
Optimizing Sorts |
| Prerequisites: |
Introduction to ASE12.5.3
System & Database Administration for ASE12.5.3 |