ASE Practical Systems Administration

Length: 5 Days
Prerequisites:  Solid understand of SQL


Overview

Learn what tools and resources manage Adaptive Server. Learn how to install, monitor, and maintain an Adaptive Server and its databases.
It provides guidelines for a practical approach to administering  and maintaining a Sybase Adaptive Server.

Key Benefits:  When you complete this course you will have the knowledge you need to go back to your office to complete tasks such as,
installing ASE, Review Your Database Design, Manage User Access, Learn How to Backup and Recover your Database, Perform Maintenance Tasks
and Troubleshoot and Solve Problems as they Occur.

Outline


Chapter 1. Architecture Overview

•  Systems Administration
•  Definition
• usage
• Interrelation of System Tables
• Proceudures

Chapter 2. Server Installation

• Hardware Requirements
• Installation Steps
• Determining Sort Order & Character Sets
• The Master Device
• Name & Connection Information
• Interfaces
• RUNSERVER
• Error log Files
• Providing Access
• Starting & Stopping the Server

Chapter 3. Resource Definition

• Disk Initialization
• Default Disks
• Setting Up
• Activating & Deactivating Disk Mirroring
• Device Migration By Mirroring
• Mirroring the Master Device
• RAID Issues

Chapter 4. Parallel Query

• Intro to Parallel Query
• Configuration
• Maintenance

Chapter 5. 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
• Model Database
• Defining Segments
• Placing Objects on Segments
• Getting Info on Segments
• Heap Tables

Chapter 6. Security

• Standard Roles
• Managing Server Logins & Passwords
• Adding Users, Guests, Aliases & Groups to Databases
• Relating syslogins, sysusers, & sysalternates
• Grant & Revoke Commands
• Object Dependency Security

 

 Chapter 7.  Advanced Security

• System Roles
• User Defined Roles
• Integrated Security

Chapter 8.  Logging & Recovery

• Understanding the Recovery Process
• Managing the Adaptive Server Transaction Log
• Issues in Speeding Recovery

Chapter 9. Backup & Restore

• Performing Full Database Backups
• Incrementally Backing Up Your Database
• Restoring Your Database From Backup
• Point in Time Restore
• Thresholds
• Rebuilding Master
• Scenarios

Chapter 10. Periodic Maintenance

• Server Level Maintenance
• Database Level Maintenance
• Table Level Maintenance

Chapter 11.  Memory Configuration and Tuning

• Memory
• Configuration Variables
• Performance Monitoring

Chapter 12.  Resource Governor

• What Is Resource Governor?
• Setting Up Resource Limits

Chapter 13.  Logical Process Manager

• What is the Logical Process Manager?
• Engine Affinity
• Execution Precedence

Chapter 14.  Managing DOL Tables

• DOL Page Maintenance
• Monitoring Space Management in DOL Tables
• Managing Space in DOL Tables
• Optdiag
•  Understand Histogram Information

Chapter 15.  Auditing

• When to Use Auditing
• Configuring Auditing
• Understand Troubleshooting Techniques
• Troubleshooting
• Class Discussion of Problems
• Resolution of Problems

Back to Course Listing