
Sybase Training Overview:
The Sybase Performance and Tuning for database administrators class provides the students with a detailed understanding of the methods that can be used to provide for the most effective performance of their Sybase relational database management systems. Students will be presented with numerous step by step procedures to implement in order to obtain the most efficient processing of the Sybase server. The Sybase database administrators will also be shown how they can work with their developers to help generate the most effective Sybase code.
Upon successful completion of this course, participants will be able to implement numerous tuning and performance factors that will provide them with a highly tuned Sybase server.
Sybase Training Objectives:
Sybase Training Prerequisites:
Students should have at least 3 months experience as an Sybase database administrator. A knowledge of Sybase programming is useful, but not required.
Sybase Training Audience:
This course is specifically recommended for database administrators who require an in-depth understanding of the means by which to tune their Sybase servers.
Course duration:
4 days
Sybase Training Course outline
Architectural overview of Sybase
Logical versus Physical Devices
Sybase Mirroring
System Information
Performance considerations for creating and sizing databases
Performance considerations for creating and sizing logs
Database options for maximizing performance
Transaction processing
Resource Management Performance
Utilizing the Logical Process Manager for performance
Tuning Memory Management
Locking Principles
Performance Monitoring
Parallel Concepts
Tools
Working with developers