Training Course:Performance and Tuning: Configuring Adaptive Server Enterprise (Certificate)School/Trainer:Sybase, Inc.
Ottawa, Toronto, Ontario, Canada
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:(978) 287-1626
School Address:
Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8
Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto
Search other schools for Performance and Tuning: Configuring Adaptive Server Enterprise training resources.
Other training courses offered by Sybase, Inc.:
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
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:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
|
