http://www.toadworld.com/platforms/sql-server/w/wiki/9805.performance-tuning.aspx
Performance Tuning
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.
- Project Lucy - includes videos on how to get started with Project Lucy.
- Wait Events
- Writing a SQL Server Performance Report - includes a video explanation tutorial.
- Using the Right Indexes for Optimal Performance
No comments:
Post a Comment