Loading Course Schedule...
PT20523
Summary
Skills gained from this class include:
- 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
Prerequisites
Before taking this course, students must have taken the System and Database Administration: Adaptive Server Enterprise course or have equivalent experience.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for database administrators and system administrators.
Topics
Principles of Performance and Tuning
- Architectural Overview
- The Tuning Toolbox
- Locking Principles
- Fragmentation
- Multiple Engines
- Named Caches
- Specialty Cache Settings
- Procedure Cache and Statement Cache Tuning
- Device Usage
- Table Partitioning
- Optimizer Statistics
- Parallelism
- Logical Process Manager
- The Bulk Copy Program (bcp)