Topic Sections

• Tuning Overview
• Configuring Database Files for Optimal Perfomance
• Configuring SQL Server for Optimal Performance
• Latches
• Optimization Tips & Techniques
• Query Processing
• Recommended Best Practices for Tuning
• Hardware Tuning
• Performance Baselines - why you need to capture a baseline and measure performance once a quarter.
• SAN Performance Tuning with SQLIO
• SQL Server Query Optimizer
• SQL Server Profiler - includes videos on how to get started with Profiler.
• Wait Events
• Writing a SQL Server Performance Report - includes a video explanation tutorial.
• Using the Right Indexes for Optimal Performance