Performance tuning on SQL Server is difficult. Sifting through the huge volume of tuning information available on various web sites - which counters to look at, which queries to run, etc. – can overwhelming. Part of the challenge is just to figure out where to start.
One very important area that is often overlooked is to understand how the SQL that is executed on the server affects performance and how to use that understanding to tune performance more effectively.
This paper explores a number of key points that you can take away and apply to your own environment:
Acquisitions - Enstratius, RemoteScan, StatSoft