End-to-End Troubleshooting SQL Server with Kevin Kline - podcast episode cover

End-to-End Troubleshooting SQL Server with Kevin Kline

Nov 19, 201436 minEp. 395
--:--
--:--
Download Metacast podcast app
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

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.

For the best experience, listen in Metacast app for iOS or Android