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 ...

Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.