cracking execution plans by sarabpreet singh anand

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 : sarab@sarabpreet.com sarabpreet.anand@gmail.com

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:

Thank you

Request you to provide your valuable feedback

@Sarab_SQLGeekSarab@Sarabpreet.comSarabpreet.anand@gmail.com