After completing SQL Server 6.5: Tuning for Performance, the user should 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

Configuring and Tuning SQL Server
 

	Configuration Variables
	Setting Configuration Options

Optimizing SQL Server Configuration Options
 

	Memory Utilization
	Validating Memory Configuration
	Optimizing Parallel Read Operations

Measuring SQL Server System Performance
 

	Using Performance Monitor
	Monitoring SQL Server Performance Counters

Miscellaneous Performance Topics
 

	BCP and Performance
	tempdb and Performance

This course is distributed with
 

	Exercises, with sample files, that allow users to practice in SQL Server 6.5
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to the SQL Server 6.5 product
	A SQL Server 6.5 glossary