Sybase Performance and Tuning

PT2276
Summary
Students rave about this course on tuning SQL Server. Users with some experience in Sybase will learn enough about what makes Sybase tick to build applications that deliver the performance they only read about in the magazines.
Prerequisites
Students should have taken Introduction to SQL for Sybase Adaptive Server and Introduction to Sybase Adaptive Server or have equivalent experience. At least 6 months of experience with Sybase is recommended before attending the Performance and Tuning class, but is not an absolute requirement.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for programmers and systems administrators.
Topics
  • Introduction
  • Logical Design Issues
  • Physical Design Issues
  • Index Selection
  • Using the Query Optimizer
  • Other Techniques for Determining Query Paths
  • How to Bypass the Optimizer
  • Locking
  • Deadlock Detection and Avoidance
  • Performance Metrics

Related Scheduled Courses