Execution Plans

Question

Execution Plans

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
January 30, 2014 at 10:17 pm

#72507

Comments posted to this topic are about the item Execution Plans
January 31, 2014 at 1:45 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Nice question, Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

sunil.lath 98534 Grasshopper Points: 13 More actions · Answer 2

Very handy query to have but what is the best way to filter the result set. For example you are interested in plans related to a certain table? I think that could be very useful to know.

call.copse SSCoach Points: 18050 More actions · Answer 3

Nice one. I guessed this by simply assuming it was the most complicated looking one!

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

Umer Akram

SSC-Insane

Points: 22209

January 31, 2014 at 6:12 am

#1685016

nice question and a very handy query as well 🙂

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Good question that's always on point. Nice way to end the week.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Cliff Jones SSChampion Points: 10547 More actions · Answer 7

sunil.lath 98534 (1/31/2014)
Very handy query to have but what is the best way to filter the result set. For example you are interested in plans related to a certain table? I think that could be very useful to know.

This is how I do that:

SELECT cp.objtype AS ObjectType,

OBJECT_NAME(st.objectid,st.dbid) AS ObjectName,

cp.usecounts AS ExecutionCount,

st.TEXT AS QueryText,

qp.query_plan AS QueryPlan

FROM sys.dm_exec_cached_plans AS cp

CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp

CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st

WHERE st.TEXT like '%xxxxxx%' <-- Table Name here

zymos SSCommitted Points: 1960 More actions · Answer 8

Thanks for the great question covering the DMV's, XML and Execution plans. 🙂

steve.jacobs SSCommitted Points: 1830 More actions · Answer 9

Steve,

I use this a lot. I love DMV\DMF. Thanks for the question.

+1

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 10

PChiragS

SSCarpal Tunnel

Points: 4965

February 3, 2014 at 7:10 am

#1685476

Nice and easy one..

Thanks Steve..

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Revenant

SSC-Forever

Points: 42467

February 3, 2014 at 12:15 pm

#1685608

Nice, nice. Thanks, Steve!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

EZ PZ.

Thanks.

Here is an article that discusses a query to see these execution plans too - http://www.sqlservercentral.com/articles/Execution+Plans/103484/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Hany Helmy SSChampion Points: 13921 More actions · Answer 13

Good question, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant