Performance optimization on SQL Server is difficult. A vast array of information exists on how to address performance problems in general. However, there is not much information on the specifics and even less information on how to apply that specific knowledge to your own environment.
In this whitepaper, I discuss the 10 things that I think you should know about SQL Server performance. Each item is a nugget of practical knowledge that can be immediately applied to your environment.
Patrick O'KeeffeSenior Software Architect, Dell Software
Acquisitions - Enstratius, RemoteScan, StatSoft