execution plan window

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » execution plan window

execution plan window

Rate Topic

Display Mode

Topic Options

Author

Message

shanghaigirl-1125377

Posted Monday, February 04, 2013 2:02 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:07 PM
Points: 39, Visits: 1,106

I am trying to observe the graphic execution plan, but my query is big. Is there any way that I can turn off the top part of the execution plan window - the Query and missing index session? Because every time I move my mouse, it's like trying to load that big query. Thanks.

Post #1415486

SQLRNNR

Posted Monday, February 04, 2013 2:23 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

You can load the plan into SQL Sentry Plan explorer. It is a lot more user friendly.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1415496

Grant Fritchey

Posted Tuesday, February 05, 2013 3:55 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:55 AM
Points: 13,381, Visits: 25,165

You can't turn that part off.

----------------------------------------------------
"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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1415701

shanghaigirl-1125377

Posted Tuesday, February 05, 2013 8:04 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:07 PM
Points: 39, Visits: 1,106

Thank you.

Post #1415868

Ed Wagner

Posted Wednesday, February 06, 2013 6:32 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,856, Visits: 528

I agree with SQLRNNR - SQL Sentry Plan Explorer is a good product. There's a free version and a paid version, which is pretty cheap. It gives you the "Oracle Explain Plan"-style view in a grid in addition to an improved graphical view.

Post #1416470

Sean Pearce

Posted Wednesday, February 13, 2013 6:07 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 5:26 AM
Points: 350, Visits: 1,333

shanghaigirl-1125377 (2/4/2013)

Just avoid that section with your mouse

http://thesqlguy.blogspot.com/

Post #1419450

« Prev Topic | Next Topic »

Permissions