SESSION Details

Here’s the execution plan … now what?

You have learned the relevance of execution plans. You know where to find them, and you’ve been taught the basics of how to read them. You’ve looked at some of the clean, simple execution plans that presenters used in classroom training, or at conferences, and you feel confident that you can work with them. And then you get your first problem query at your workplace, you look at its execution plan, and you just want to crawl under a rock and cry.

Real code is much more complicated than demo code. Real code translates to large, complex, and often messy execution plans. The principles of reading execution plans still apply, but the plan is large and messy and you struggle where to even begin.

If your query uses a lot of I/O, then which operators are to blame? If your query uses a lot of memory, then what area is responsible? What are some things you should always look at?

Knowing the root cause of a problem can help find a cure. Knowing where to look in a large execution plan can help you find that root cause faster!

Feedback link https://sqlb.it/?6999

Starts: 15:20 11th Mar 2022
Ends: 16:10 11th Mar 2022

Q&As

Short Description
- You know where to find an execution plan. You have taken your first steps reading them. But how are you going to apply this knowlledge to real world problems?

Slidedeck Link

Here's the execution plan - now what.zip

Speakers

Hugo Kornelis

Tags

AWSAzureGCPOn PremisesIAAS VM BasedDataOpsFuture DBADevelopingOptimisingAzure SQL DatabaseDatabase EngineSQL 2019IntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.