This course provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance.
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
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 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
