Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Greater London
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course teaches database administrators how to tune an Adaptive Server for optimal performance. It explores Adaptive Server architecture in depth, and includes sections on designing databases for performance, managing Adaptive Server system resources (CPUs, disks, I/O), choosing appropriate locking schemes, optimizer statistics, SMP features, relevant data structures, and parallel processing. Prerequisites - Fast Track to Adaptive Server Enterprise
- System and Database Administration: Adaptive Server Enterprise
Course Outline - Tuning transaction processing for OLTP, DSS, and batch applications
- Benchmarking techniques
- Optimizing hardware device usage and space management
- Choosing locking schemes
- Configuring lock promotion at server, database, and object levels
- Working with multiple engines in the SMP environment
- Data cache configuration and tuning, and cache partitioning
- Procedure cache configuration and tuning
- Working with tempdb
- Optimizer statistics
- Working with parallel queries
How to make a booking for the EDB551 course
|
