1 / 9

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

austin-baldwin
Download Presentation

Cracking Execution Plans By Sarabpreet Singh Anand

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Cracking Execution Plans By Sarabpreet Singh Anand

  2. 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

  3. T-SQL? • Declarative • You tell – what to do. • But you don’t tell How to do….! • Exceptions: • Hints • Plan guides • Etc.

  4. Query Execution Plan What is a query execution plan Build from many operator blocks Query tree

  5. Execution Plans What all it offers How it is useful What all it lacks? Cost = time? (Myth)

  6. 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

  7. 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

  8. Thank you  • Request you to provide your valuable feedback • @Sarab_SQLGeek • Sarab@Sarabpreet.com • Sarabpreet.anand@gmail.com

More Related