I'm constantly on the lookout for good resources concerning performance tuning and troubleshooting on SQL Server. In all honesty, though, I didn't think we would see anything for SQL Server 2005 until well into 2006. Boy, was I wrong!
Some of the top talent in the Microsoft SQL Server engine team and customer service team have teamed up to write an truly excellent white paper on troubleshooting performance for SQL Server 2005. The authors include Sunil Agarwal,
Let me know what you think.