Performance and Tuning: Configuring Adaptive Server Enterprise

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:

'' 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, and parallel processing. Examine the use of Sybase performance monitoring utilities (Sybase Central, 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:
Reconfigure the server without a reboot
Discuss tradeoffs involved in performance tuning
Enable parallel queries and correctly configure parallel sort parameters
Manage multiple engines and space issues related to table locking schemes
Use Sybase utilities to optimize performance
Identify and correct problems in database physical design
Properly configure memory and choose appropriate cache strategies
Choose the appropriate table locking scheme for a give application
Configure lock promotion at the server, database, and object levels
Course Topics :
Dynamic reconfiguration, using different page sizes, tuning transaction processing for OLTP, DSS, and batch applications, optimizing hardware device usage and space management, and configuring lock promotion at the server, database, and object levels.

Who Should Attend : Database Administrators

Prerequisites :

Fast Track to Adaptive Server Enterprise /11.9/12.0/12.5
System and Database Administration: Adaptive Server Enterprise 11.9/12.0/12.5

...''

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.

Harness the Power with Configurable Parameters
Using SybMigrate
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
Advanced Administration and Troubleshooting for Adaptive Server
Troubleshooting Adaptive Server Data Structures
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

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.