Troubleshooting Adaptive Server Data Structures

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Gain a deeper understanding of the data structures inside Sybase Adaptive Server Enterprise (ASE) 12.5.0.1 and how they are allocated and de-allocated. This expert-level course gets you ¡°under the hood¡± and exposes you to in-depth technical detail. Use this knowledge to prevent potential problems from database corruption and to reduce time working with Sybase Technical Support. Troubleshoot, recognize, locate, and resolve corruption problems to save time and data. Learn to read and understand the contents of the transaction log and troubleshoot full logs. Understand the implications for performance, logging, and recovery. Possible database corruption, potential resolutions, and tradeoffs are discussed. Learn how to use Sybase utilities to troubleshoot the server. Lab time covers many dbcc commands and is used to troubleshoot the server for various types of database corruption.
Course Objectives :
Upon completion of this course, you will be able to:
Understand the inner workings of Adaptive Server data structures
Use dbcc to discover potential data corruption problems
Identify and resolve different types of data corruption
Understand how transactions are logged and troubleshoot full logs
Read and understand the contents of the transaction log
Use Recovery Fault Isolation (RFI)
Course Topics :
Details of physical storage, DBINFO, DBTABLE, dbcc usage, page management structures and processes (allocation pages, OAL pages, GAM pages), data, index, control and text/image page layout for APL and DOL tables, page linkage, disk init, and dsync, index structure, page and extend allocation/de-allocation, logging (how to read log pages in detail), recovery internal, and recovery fault isolation and bypass recovery.

Who Should Attend : Database Administrators, Performance Tuning Specialists, System Administrators

Prerequisites : System and Database Administration: Adaptive Server Enterprise 12.5 (EDB354) and two to four years database administration experience


...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Powering Up to ASE Interim Releases
Introduction to SQL Expert
Behind the Scenes with DBCC Commands
Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server
Performance and Tuning: Adaptive Server Enterprise Query Optimizer
Logical Database Design
Physical Database Design
XML Certification Boot Camp
Introduction to Cascading Style Sheets
Introduction to JavaScript
Introduction to Java 2 Programming
Intermediate Java 2 Programming
Advanced Java 2 Programming

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.