Training Course:Performance and Tuning: Configuring Adaptive Server Enterprise (Certificate)School/Trainer:Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Learn to tune Adaptive Server Enterprise (ASE) for optimal performance and explore ASE architecture in depth. Study topics that include designing databases for performance, diagnosing and correcting performance problems, managing ASE system resources (CPUs, disks, I/O), optimizer statistics, SMP features, relevant data structures, benchmarking turning methodology and techniques, table partitions, and parallel processing. Examine the use of Sybase performance monitoring utilities (Monitoring Tables, sp_sysmon, system Stored Procedures) and major performance trade-offs. Gain insight on choosing appropriate locking schemes.
Course Objectives :
Upon completion of this course, you will be able to:
Discuss tradeoffs involved in performance tuning
Use sp_sysmon and other utilities to tune the server for performance gains
Properly configure memory for optimal performance
Manage multiple engines
Configure, tune, and size data, procedure, and partitioned caches
Identify and correct problems in database physical design, including table partitions
Use statistics to manage space on DOL tables and indexes
Choose the appropriate table locking scheme for a given application
Reconfigure Adaptive Server dynamically
Improve performance of tempdb by sizing, placement, and solving locking
Course Topics:
Principles of Performance and Tuning
Adaptive Server Architectural Overview
The Tuning Toolbox
Locking Principles
Data-Only Locking Tables and Table Fragmentation
Working with Multiple Engines
Named Caches
Large I/O and MetaData Caches
Cache Partitioning and Cache Strategies
Procedure and Statement Cache
Optimizing Device Usage
Table Partitioning
Optimizer Statistics
Parallel Concepts
Parallel Tuning
Tuning with the Logical Process Manager
Bulk Copy Tuning
Putting It All Together
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.sybase.com/
Phone:1-800-8-SYBASE
School Address:
Manhattan Learning Center
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036
Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612
Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,
Search other schools for Performance and Tuning: Configuring Adaptive Server Enterprise training resources.
Other training courses offered by Sybase USA:
IT Project Management
Project Management
PMP Exam Prep
ASE 15 MIGRATION FOR DEVELOPERS
ASE 15.0 Query Optimization
SYBASE IQ 15 MIGRATION
Migrating to Sybase IQ 15
POWERDESIGNER 15 MIGRATION
POWERBUILDER 11.5 MIGRATION
Moving to PowerBuilder 11.5
Advanced Administration and Troubleshooting for Adaptive Server Enterprise
Troubleshooting Adaptive Server Data Structures
SQL
Quick-Start for ASE Administrators of SAP/BusinessOne
High Availability: Adaptive Server Enterprise 12.0 Companion Server
Performance & Tuning using MDA Tables
Open Client Programming Using Client Library
Open Server Programming
Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
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:
You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself. |
|
|
