http://blogs.technet.com/beatrice/archive/2009/04/15/troubleshooting-performance-problems-in-sql-server-2008.aspxA new great whitepaper to bookmark amongst your favourites: Troubleshooting Performance Problems in SQL Server 2008 http://msdn.microsoft.com/en-us/library/dd672789.aspx This documentation provides step-by-step guidelines for diagnosing and troubleshootingit-ITCommunityServer 2.1 SP1 (Build: 61025.2)