Description
Performance and Tuning Configuring Adaptive Server Enterprise 15.7
(EDB553)
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
Audience
- Database Administrators
- Open Interface Developers
Prerequisites
- Fast Track to Adaptive Server Enterprise 15.0/16.0
- System and Database Administration: Adaptive Server Enterprise or equivalent work experience to Fast Track and System and Database Administration.
Instructors
19 Courses
228 Students
2 Reviews