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.”, October 2005.

Marathe, Aurun. “Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005.”, July 2004.

Patel, Burzin A. Forcing Query Plans.”, November 2005.

“SQL Server Engine Tips.” 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.