|
|
Systems Administration for
Sybase Adptive Server
| Duration: 5 days |
| Participants: This course is designed for those administering a Sybase Adaptive Server. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Use the tools and resources to manage a Sybase Adaptive Server. - Install, monitor, and maintain an Adaptive Server and its databases. - Administer a Sybase Adaptive Server and its databases. |
|
Overview:
- This course provides guidelines for a practical approach to administering a Sybase Adaptive Server. It teaches participants how to install, monitor, and maintain and Adaptive Server and its databases. Key tools and resources for managing an Adaptive Server are also covered. |
| Prerequisites: Attendance at the 'Introduction to Sybase Adaptive Server' course or equivalent knowledge. Some experience working with a Sybase Adaptive Server is also helpful as is a strong knowledge of DML SQL. |
| Format: Lecture and discussion with hands-on exercises. |
|
Topic Outline:
- Architecture Overview System Administration Definition, Usage, and Interrelation Of System Tables Procedures - Server Installation Hardware Requirements Installation Steps Determining Sort Orders and Character Sets The Master Device Name and Connection Information Interfaces RUNSERVER Errorlog Files Providing Access Starting and Stopping a Server - Resource Definition Disk Initialization Default Disks Setting Up Activating and Deactivating Disk Mirroring Device Migration By Mirroring Mirroring the Master Device RAID Issues - Parallel Query Introduction to Parallel Query Configuration Maintenance - Databases Assigning Device Fragments to Databases Database Logs Use of the Model Database Monitoring Disk Space Utilization Setting Options Tempdb Changing Ownership Adding more Log Space Defining Segments Placing Objects on Segments Getting Info on Segments Heap Tables - Security Standard Roles Managing Server Logins and Passwords Adding Users, Guests, Aliases, and Groups to Databases Relating syslogins, sysusers, and sysalternates Grant, Revoke Commands Object Dependency Security - Advanced Security System Roles User Defined Roles Integrated Security - Logging and Recovery Understanding the Recovery Process Managing the Adaptive Server Transaction Log Issues in Speeding Up Recovery - Backup and Restore Performing Full Database Backups Incrementally Backing Up Your Database Restoring Your Database from Backup Point in Time Restore Thresholds Rebuilding Master Scenarios - Periodic Maintenance Server Level Maintenance Database Level Maintenance Table Level Maintenance - Memory Configuration and Tuning Memory Configuration Variables Performance Monitoring - Resource Governor What is Resource Governing? Setting Up Resource Limits - Logical Process Manager What is the Logical Process Manager? Engine Affinity Execution Precedence - Managing DOL Tables DOL Page Maintenance Monitoring Space Management in DOL Tables Managing Space in DOL Tables Optdiag Understanding Histogram Information - Auditing When to Use Auditing Configuring Auditing Understanding Troubleshooting Techniques - Troubleshooting Class Discussion of Problems Resolution of Problems |