cracking execution plans by sarabpreet singh anand
TRANSCRIPT
Cracking Execution Plans
By
Sarabpreet Singh Anand
Sarabpreet Singh Anand
SQL Server MVP MCTS, MCITP: Admin, MCT certifications Vice President & Co-Founder of SQLServerGeeks.com Expert in handling VLDBs & Disaster Management
Conducted many SQL Server Boot camp Trainings Regular Speaker:
UG Events, In-person Events & Webcasts Microsoft Community Tech Days (CTD),Etc
Follow Me @Sarab_SQLGeek Email : [email protected] [email protected]
T-SQL?
DeclarativeYou tell – what to do.But you don’t tell How to do….!Exceptions:
Hints Plan guides Etc.
Query Execution Plan
What is a query execution planBuild from many operator blocksQuery tree
Execution Plans
What all it offers
How it is useful
What all it lacks?
Cost = time? (Myth)
Estimated & Actual
Estimated: compile Showplan_text Showplan_All Showplan_XML Graphical plan Sys.dm_exec_query_Plan Sys.dm_exec_text_query_plan
Actual Plan set statistics profile set statistics xml graphical plan
How to get Execution Plans What all information is importantDiff ways to get the informationWhat all methods are deprecatedUsing Extended Events to get execution plans\info
Let’s see:
