Click here to monitor SSC

FatherJack

SQL Q+A forum at ask.sqlservercentral.com | Follow fatherjack on Twitter

Using SQL Sentry Plan Explorer

Published Thursday, November 25, 2010 3:00 PM

This is a quick tip that I hope will help you use SQL Sentry's Plan Explorer tool. It's a really great tool for viewing Execution Plans - something that SSMS isn't too great at.

If you don't have the tool then you can download it for free from http://www.sqlsentry.net/plan-explorer/sql-server-query-view.asp.

SSEPE01So, just a little setup is required before I can show you the tip in full. Create a directory on your Desktop called Execution Plans and copy a shortcut to the Execution Plan Explorer application into it.

Once that is set you need an execution plan, so off to SSMS and write a query. Here's one I prepared earlier. Well, to be brutally honest its a simple select from an AdventureWorks view but there's a plan we can use. Click the Include Actual Execution Plan button
SSEPE02
and then run the query. When the query completes you get an extra tab that contains the execution plan SSEPE03

Click that tab, and then right click in any part of the plan to get the popup menu to save the plan
SSEPE04

Now save the plan in the directory we created right at the start, giving it a name that is descriptive so that you can identify it easily later on. Here is the neat bit. No need to open the tool and then search for SSEPE05your plan or find the plan and go through the 'open with' dance. Simply go to the directory on your desktop and drag the execution plan on to the Plan Explorer tool shortcut. It will open the plan and let you examine your query's plan.

Lovely.

SSEPE06

If you are new to the tool then Aaron Bertrand Twitter|Blog has done a great explanation of how it works here - http://www.mssqltips.com/tip.asp?tip=2170.

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Good Will Hunting | Ultimate Fishing and Hunting Blog said:

November 26, 2010 5:55 AM
 

Aaron Bertrand said:

Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4 . This week, it's SQL
December 22, 2010 7:09 PM
 

SQL Server Links and news for the week 26/11/10 said:

March 4, 2012 9:23 AM

What do you think?

(required) 
(optional)
(required) 

About fatherjack

DBA since 1999 working for not-for-profit company. http://twitter.com/fatherjack,
Latest articles
Checking Out SQL Backup Pro 7’s New Automatic Backup Verification
 Wouldn't it be great to offload the daily chore of checking the integrity of your production... Read more...

Chuck Lathrope: DBA of the Day
 Chuck Lathrope was a finalist for the Exceptional DBA of the Year award in 2009. We contacted him to... Read more...

Backups, What Are They Good For?
 Pixar recently confessed, in an engaging video, that Toy Story 2 was almost lost due to a bad backup,... Read more...

C# Async: What is it, and how does it work?
 The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is... Read more...

SQL Server 2012 AlwaysOn
 SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It... Read more...