Troubleshooting Performance Problems in SQL Server 2008

Microsoft has published an interesting article (97 pages) about troubleshooting Performance Problems in SQL Server 2008. This is a must to read for people interesting in performance analyzing and optimization of your SQL Server.  It provide information to find:

1. Resource bottlenecks
2. CPU bottlenecks
3. Memory bottlenecks
4. I/O bottlenecks
5. Tempdb issues
6. Slow Running Queries.

 The full article can be found here:  http://msdn.microsoft.com/en-us/library/dd672789.aspx

Enjoy it.