Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 

Troubleshooting ASE Data Structures

Course Code: EDB555      Days: 4
Show all Sybase Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Greater London
London 02/12/08 £ 2,000
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

Designed to expose you to the data structures used by Adaptive Server internally and how they are allocated and deallocated, this course provides the understanding required to troubleshoot the server for different types of data corruption problems.

Audience

  • Database administrators
  • System Administrators
  • Performance Tuning Specialists

Skills Gained

  • 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)database

Prerequisites

  • Fast Track to Adaptive Server Enterprise
  • System and Database Administration: Adaptive Server Enterprise
  • Minimum 6 months of DBA experience with Adaptive Server Enterprise
  • Highly recommended: the Advanced Administration and Troubleshooting for ASE course and/or the
  • Performance and Tuning: Configuring Adaptive Server Enterprise courseFast Track to Adaptive Server Enterprise or equivalent experience and Logical Database Design

Course Outline

  • dbcc Usage
  • Details of Physical Storage, DBINFO, DBTABLE
  • Page Management Structures and Processes: Allocation Pages, OAM Pages, GAM Pages
  • Data, Index, Control and Text/Image Page Layout for APL and DOL Tables, Page Linkage, disk init, and dsync
  • Index Structure
  • Logging; How to Read Log Pages in Detail
  • Recovery Internals
  • Recovery Fault Isolation, Bypass Recovery


How to make a booking for the EDB555 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership