Understanding Execution Plans - Erin Stellato

Video Description

If you have struggled to understand why a query takes too long to execute, or don’t know where to start when a query requires a lot of I/O or consumes significant CPU, then we should talk about execution plans. When you write a query for SQL Server, you are asking the engine to return a specific set of data, but the optimizer decides how to get that information; an execution plan provides details about what SQL Server decided to do, and it’s a great place to start to understand why a query may not perform as you hoped or expected. This session will include numerous demos that show: - How to capture an execution plan - How to understand what objects are being accessed - The basic operations in a plan In the demos we will also highlight other valuable information in a plan and how to identify potential problems. You will leave the session with practical information about execution plans that you can put to use immediately when you’re back at your desk and looking at a query that just didn’t run the way you anticipated. This session is the first session in the SQL Performance for Developers Learning Pathway. For more information please visit our Learning Pathways page. Watch the session recording from PASS Summit 2019. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: http://www.red-gate.com/pass