How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)

Prefer a written transcript? Go to https://littlekendra.com/2017/09/22/how-do-i-analyze-a-sql-server-execution-plan/

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.

Тэги:

#SQL_Server #Database_Administrators #DBA #Performance_Tuning #Developers #Execution_Plan #Query_Plan

Скачать видео