Detail kurzu
EDB553 - Performance and Tuning: Configuring Adaptive Server Enterprise
SAP Slovensko s.r.o.
Popis kurzu
Goals
- 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
Obsah kurzu
Content
- 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
Notes
- 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.
Popular tags No tags submitted for this course yet
Cieľová skupina
Audience
- Database Administrators, Open Interface Developers
Hodnotenie
Organizátor
Podobné kurzy
podľa názvu a lokality
