Search results for “execution plan”

  1. Home
  2. Search Results

07 – Execution Plans are Lying Liars (24m)

When you look at the arrows on an actual plan, what do the arrow sizes mean? When you see the list of wait stats, they’re accurate, right? Buckle up and prepare to be disappointed – a lot of what you see in a query plan just flat out isn’t true. Here is the demo script:…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Performance Tuning in 21 Demos or Recorded Class Season Pass, or log in if you already shelled out the cash.
Read More

2.2 Problems in Execution Plans (32m)

In this module, we cover how to get an execution plan, execution plan terminology, how to read an execution plan, and finding common problems in plans. Transcript: Hello, I’m going to assume that you just got here from the reading execution plans module. If you’re here without watching that, you should probably watch that first…

To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Read More

2.1 Reading Execution Plans (24m)

Let’s talk about how to get different kinds of query plans, basic terminology, reading execution plans, where costs come from and common operators and query plans. Then in the next module, we’ll talk about interpreting plans to find problem areas. Transcript: Hello, I’m Erik, I’m from Brent Ozar unlimited, a limited liability corporation and in…

To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning, or log in if you already shelled out the cash.
Read More

What’s the Difference Between Estimated and Actual Execution Plans?

I’m going to use the dbo.Users table in the StackOverflow demo database and run a pretty simple query: Transact-SQL SELECT * FROM dbo.Users WHERE DisplayName LIKE 'Brent%'; 123 SELECT *FROM dbo.UsersWHERE DisplayName LIKE 'Brent%'; First, hit Control-L in SSMS and get the estimated execution plan. Here it is: Estimated execution plan: https://www.brentozar.com/pastetheplan/?id=H1TeRlZke Click on the…
Read More

Announcing PasteThePlan.com: An Easier Way to Share Execution Plans

Since the dawn of man, people have struggled with sharing execution plans with each other for performance tuning. Now, it’s easy. First, get yourself a plan: Get the estimated execution plan by hitting control-L or clicking Query, Display Estimated Plan. Right-click on the graphical plan, and click View XML. Copy all of that. Or even…
Read More

Improved diagnostics for query execution plans that involve residual predicate pushdown

I love stuff like this! Even though it’s not on my list of dream features, it’s pretty neat. Getting new views into what SQL is doing when queries execute is pretty cool. You can read the short and gory details at the KB here: Improved diagnostics for query execution plans that involve residual predicate pushdown…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}