EPISODE · Nov 19, 2014 · 36 MIN
End-to-End Troubleshooting SQL Server with Kevin Kline
from RunAs Radio · host Richard Campbell
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.
What this episode covers
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.
NOW PLAYING
End-to-End Troubleshooting SQL Server with Kevin Kline
No transcript for this episode yet