| Length:
5 Day |
| Overview:
Learn what tools and
resources manage a Adaptive Server. Learn how to
install, monitor, and maintain an Adaptive Server and
its databases.
It provides guidelines for a practical approach to
administering a Sybase Adaptive Server. |
| Topics Covered:
|
|
|
- Architecture Overview
System Administration, Definition, Usage, &
Interrelation Of System Tables, Procedures
- Server Installation
Hardware
Requirements, Installation Steps, Determining Sort
Orders & Character Sets, The Master Device, Name &
Connection Information, Interfaces, RUNSERVER, &
Errorlog Files, Providing Access, Starting, Stopping
Server
Resource Definition
Disk Initialization, Default Disks, Setting Up,
Activating & Deactivating Disk Mirroring, Device
Migration By Mirroring, Mirroring The Master Device,
RAID Issues
Parallel Query
Intro 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, MOdel Database,
Defining Segments, Placing Objects on Segments,
Getting Info on Segments, Heap Tables
Security
Standard Roles, Managing Server Logins and
Passwords, Adding Users, Guests, Aliases, & Groups
to Databases, Relating syslogins, sysusers, &
sysalternates, Grant, Revoke Commands, Object
Dependency Security
Advanced Security
System Roles, User Defined Roles, Integrated
Security
Logging & Recovery
Understanding the Recovery Process, Managing the
Adaptive Server Transaction Log, Issues in Speeding
Up Recovery
Backup & Restore
Performing
Full Database Backups, Incrementally Backing Up Your
Database, Restoring Your Database From Backup, Pint
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,
Understand Histogram Information.
Auditing
When to Use Auditing, Configuring Auditing,
Understanding Troubleshooting Techniques
Troubleshooting
Class
Discussion of Problems, Resolution of Problems
|
|
|
|
