Wednesday, April 15, 2009

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.

No comments: