90 likes | 221 Views
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
E N D
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? • Declarative • You 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 plan Build from many operator blocks Query 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
Let’s see: How to get Execution Plans What all information is important Diff ways to get the information What all methods are deprecated Using Extended Events to get execution plans\info
Thank you • Request you to provide your valuable feedback • @Sarab_SQLGeek • Sarab@Sarabpreet.com • Sarabpreet.anand@gmail.com