As promised during the live meeting I’m posting some interesting resources:

· SQL Server 2005 Performance Tuning Waits & Queues: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

· Troubleshooting Performance Problems in SQL Server 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

· SQL Server I/O Basics Chapter 2: http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

· Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005: http://technet.microsoft.com/en-us/library/cc966425.aspx

· Troubleshooting SQL Server 2005/2008 Performance and Scalability Flowchart: http://sqlcat.com/presentations/archive/2008/04/18/troubleshooting-sql-server-2005-2008-performance-and-scalability-flowchart.aspx

Troubleshooting Performance Problems in SQL Server 2008: http://msdn.microsoft.com/en-us/library/dd672789.aspx

Download the slide deck.