|
This course provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance.
Objectives:
After completing this course, students will be able to:
- Select the appropriate settings for locks
- Configure the number of worker threads
- Select the appropriate settings for read ahead
- Identify the benefits of installing the tempdb database in RAM
- Tune and monitor memory use
Topics:
- Configuring and Tuning SQL Server
- Optimizing SQL Server Configuration Options
- Measuring SQL Server System Performance
- Miscellaneous Performance Topics
|