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.
Sybase Training Objectives:
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 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
- Pages
- Devices
- Networking
- Interfaces file
- Errorlog file
Logical versus Physical Devices
- Performance Implications
- Raw versus Filesystem
- Dsync option
Sybase Mirroring
System Information
- System Tables
- System procedures
Performance considerations for creating and sizing databases
Performance considerations for creating and sizing logs
Database options for maximizing performance
Transaction processing
- Transaction logging
- Checkpoints
- Recovery processing
- Suspending transactions
Resource Management Performance
- Enabling resource limits
- Enforcements
- Actions
Utilizing the Logical Process Manager for performance
- Logical process manager procedures
- Engine groups
Tuning Memory Management
- Configure, tune, and size data, procedure, and partitioned caches
- Providing named cache
- Buffer pools
- Wash area
- Binding objects to cache
Locking Principles
- Data-Only Locking Tables and Table Fragmentation
Performance Monitoring
- Use sp_sysmon and other utilities to tune the server for performance gains
- Activity monitoring
- Dbcc commands
- Space utilization
- Improve performance of tempdb by sizing, placement, and solving locking
Parallel Concepts
Tools
- Bcp
- Denfcopy
- Optdiag
- Sybase Central
Working with developers
- Finding problems in coding
- Index usage
- Data distribution statistics
- Use statistics to manage space on DOL tables and indexes
- Choose the appropriate table locking scheme for a given application
- Internal methods of join processing
- Optimizer hints
- Stored procedure processing
- Abstract Plans
- Partitioning methods and performance implications
- Identify and correct problems in database physical design, including table partitions
