About Show #395
How do you troubleshoot SQL problems? Kevin Kline talks to Richard about his process for diagnosing SQL Server, starting with Windows and SQL Server event logs, then moving through wait statistics, dynamic managed views and more. The focus is on making sure you're working on the right problem. Kevin also mentions Glenn Berry's awesome blog on DMV Queries, a resource you need to use! He also talks about SQLSentry's free PlanExplorer tool for helping you understand where your query performance problems come from. And don't miss Kevin's great blog post and video on End-to-End Troubleshooting.