This course explains how to troubleshoot issues that may arise when using SQL Server 2005. It also provides information on optimizing SQL Server for the best performance.
Objectives:
List the settings that affect statistics
Describe how SQL Server deals with multiple users
Discuss indexing strategies
Describe how partitioning can improve performance
List tools that assist with maintenance tasks
Topics:
Tuning the Operating System and Hardware
Locks, Blocks, and Deadbolts
Indexing Strategies
Data Partitioning Across Servers
Working with the DTA
Using the Database Console Command
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.
