Total Time: 7 hour(s)

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

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

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.