![Dear SQL DBA artwork](https://is1-ssl.mzstatic.com/image/thumb/Podcasts113/v4/59/ab/d4/59abd4b9-e5da-2b36-9150-b2f2f8027ed0/mza_6525806208753554299.png/100x100bb.jpg)
How Do I Analyze a SQL Server Execution Plan?
Dear SQL DBA
English - September 22, 2017 13:00 - 26 minutes - 48.9 MB - ★★★★★ - 27 ratingsTechnology Education How To dba databases sqlserver sqlworkbooks Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: Do I Need to Master PowerShell?
Next Episode: Love and Hate for SSMS
A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big picture" about what execution plans are, what "cost" is, why to collect "compiled for" values, and the steps I take to analyze execution plans while performance tuning queries.