SQL - find problems - Standard solutions to random problems

Specialized Performance Troubleshooting (Part 1: How to troubleshoot Forwarded Records)

http://blogs.msdn.com/b/john_daskalakis/archive/2013/11/04/specialized-performance-troubleshooting-part-1-how-to-troubleshoot-forwarded-records.aspx

Specialized Performance Troubleshooting (Part 2: How to troubleshoot Memory problems in SQL Server)

http://blogs.msdn.com/b/john_daskalakis/archive/2013/11/11/specialized-performance-troubleshooting-part-2-how-to-troubleshoot-memory-problems-in-sql-server.aspx

Specialized Performance Troubleshooting (Part 3: How to identify storage issues at a SQL Server box)

http://blogs.msdn.com/b/john_daskalakis/archive/2013/11/18/specialized-performance-troubleshooting-part-3-how-to-identify-storage-issues-at-a-sql-server-box.aspx

How to troubleshoot SQL Server performance issues with simple tools (Part 1: How to collect a detailed Perfmon trace)

http://blogs.msdn.com/b/john_daskalakis/archive/2013/10/07/how-to-troubleshoot-sql-server-performance-issues-with-simple-tools-part-1-how-to-collect-a-detailed-perfmon-trace.aspx

http://blogs.msdn.com/b/john_daskalakis/