MP9004: Microsoft - Tuning for Performance > SQL Server 6.5

This course provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance. 

Topics:
Configuring and Tuning SQL Server
Optimizing SQL Server Configuration Options
Measuring SQL Server System Performance
Miscellaneous Performance Topics

Objectives:
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

Duration:
7 Hours