Solved

Save execution plan to another program

Posted on 2007-04-02
2
194 Views
Last Modified: 2010-03-19
I have a rather large and complex query in SQL Server 2005 which I have to sroll all over the place to view it's execution plan.  Is it possible to save the Execution Plan to another application for viewing other than using screen shots?

Is there a trick?
A third party app?

Help!?!?!
0
Comment
Question by:CLoprinzo
2 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 250 total points
ID: 18838745
This may not be what you are looking for but with Profiler you can save the showplan to a well defined XML document.

Just choosse one of teh events under Performance  section (make shure you show all events)
0
 
LVL 1

Author Comment

by:CLoprinzo
ID: 18850268
Although it added an additional step it did answer my question.  Thank you.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now