The following papers and blogs from the SQL Server engineering team can help you find additional information and ideas about performance debugging.
Agarwal, Sunil; Boris Baryshnikov; Tom Davidson; Keith Elmore; Denzil Ribeiro; and JuergenThomas. “Troubleshooting Performance Problems in SQL Server 2005.” http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx, October 2005.
Marathe, Aurun. “Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005.” http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx, July 2004.
Patel, Burzin A. “Forcing Query Plans.” http://www.microsoft.com/technet/prodtechnol/sql/2005/frcqupln.mspx, November 2005.
“SQL Server Engine Tips.” http://blogs.msdn.com/sqltips. SQL Server ...