SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Failed Abstract: Understanding Execution Plans


Failed Abstract: Understanding Execution Plans

Author
Message
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96849 Visits: 33013
I submitted this to PASS back when they didn't offer criticism of rejected abstracts, so I'm curious what might be wrong with it.

Understanding Execution Plans

Did you ever wonder if there was a way to see what happens inside SQL Server when you submit a query? Did you want to know if your indexes are getting used? Have you been curious about how SQL Server does a join between two tables? Did you just need to understand why your query is running so slow? The answers to all these questions, and more, are contained within SQL Server execution plans. My goal will be to show you how to generate execution plans and how to read them after they’re generated. You’ll learn the difference between an estimated and an actual execution plan and when to use each one. You’ll discover how to read a graphical execution plan and follow your data through the plan as it gets joined to other tables or filtered by WHERE clauses or aggregate functions. After watching this session, you’ll understand how to get detailed information out of execution plans, what operators to watch for, how to tell if the right operator is being used for your data, and all the bits and pieces of different kinds of data that are immediately available inside SQL Server execution plans.


----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Roy Ernest
Roy Ernest
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8455 Visits: 6891
To be brutally honest, the abstract looks too plain. There is nothing that catches the eye and imagination. You are stating the facts, True. But looks too plain.
Maybe you could use sentences like... "Slow and steady does not always win the race" or "Why is my query slow as tortoise? How can you dissect an execution plan? " or catchy phrases like that.

-Roy
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96849 Visits: 33013
Brutally honest is good.

So, spice it up a bit. OK. I can do that. More from others?

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96849 Visits: 33013
Where's my flipping brain...

Thank you Roy. Feedback is a gift. I appreciate it.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Steve Jones
Steve Jones
SSC Guru
SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)

Group: Administrators
Points: 144008 Visits: 19424
A few comments that stood out.

First, the power of threes. We seem wired to get caught up in threes, but you have 4 questions at the start. I'd remove one of them.

I didn't like the "...answers to these, and more..." since the "more" makes me think that you'll talk about stuff I might not be interested in.

I also don't like the "my goal". Doesn't seem forceful or confident enough.


My rewrite:

Did you ever wonder what happens inside SQL Server when you submit a query? Did you want to know if your indexes are getting used? Did you just need to understand why your query is running so slow? The answers to all these questions are contained within SQL Server execution plans. You will learn how to generate execution plans and then read them to understand what is happening inside SQL Server. You’ll learn the difference between an estimated and an actual execution plan and when to use each one. I will explain how to read a graphical execution plan and follow your data through the plan as it gets joined to other tables, filtered by WHERE clauses, or compiled in aggregate functions. After watching this session, you’ll understand how to get detailed information out of execution plans, what operators to watch for, and which ones will help your queries run faster.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96849 Visits: 33013
Oooh, that sounds good. When are you putting that session on?

Seriously, thanks. That makes sense. I'll work that in with the edits I'm going to use from Roy's feedback.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
GSquared
GSquared
SSC Guru
SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)

Group: General Forum Members
Points: 56629 Visits: 9730
It sounds mildly interesting, not critical/urgent/important. More like a point of curiousity than a tool no DBA can survive without.

Understanding Execution Plans

Every DBA runs into this. You've got a query that's not doing what you want, or not doing it fast enough. What's going on inside it? Are the indexes being used? How are the tables being joined? WHY IS IT SO SLOW!?! The answers to all of these questions and more are found within SQL Server execution plans, which are a complete pain to read if you aren't familiar with them. This presentation will clarify when and how to read an execution plan. Most importantly, how to trace down query problems in them, and the detailed information needed to solve those problems.


The abstract also sounds like it may be covering too much ground. Execution plans is a big subject. Books could be written on them :-). Cut down the abstract to what you'll actually cover in the presentation, which won't be encyclopedic or comprehensive. Is it an introduction? Intermediate? Advanced? How focused vs general?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96849 Visits: 33013
Good points Gus. This is meant to be my introductory session on execution plans (it's going, more or less intact, into my SQL Rally all day session). Thanks. Great feedback.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search