SQL Server 2008 Administration in Action

17.5. Best practice considerations: performance tuning

Performance tuning is a specialist skill. In this chapter, we've briefly covered a number of common problems in addition to looking at the waits and queues methodology for a targeted tuning approach. I encourage you to visit http://www.sqlCrunch.com/performance for links that provide broader and deeper coverage on this most important area.

• A good performance-tuning strategy considers input from multiple sources before drawing any conclusions. In this chapter, we've consider input from waits, queues, and DMVs in assisting in the diagnosis of common performance problems.

• The waits and queues methodology permits a targeted approach to performance tuning by narrowing the target to the biggest ...