By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Saving query plan

P: n/a
I would like to save a query plan (estimated or actual)
created in Query Analyzer -- paste it into a document,
or simply print. It doesn't seem to be possible to
select and copy the Execution Plan window, and printing
it creates microscopic gibberish which is a waste of
paper. Is it possible to do this?

Set showplan_text is of limited help for the SP I'm
looking at -- while analyzing the SP, it reads ahead
and complains that a temp table created inside the SP
doesn't exist (yet) and exits. Using Ctrl-K to capture
the query plan allows the SP to complete, but saving the
plan is the problem.

Thanks,
Jim Geissman

Sep 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
(ji**********@countrywide.com) writes:
I would like to save a query plan (estimated or actual)
created in Query Analyzer -- paste it into a document,
or simply print. It doesn't seem to be possible to
select and copy the Execution Plan window, and printing
it creates microscopic gibberish which is a waste of
paper. Is it possible to do this?

Set showplan_text is of limited help for the SP I'm
looking at -- while analyzing the SP, it reads ahead
and complains that a temp table created inside the SP
doesn't exist (yet) and exits. Using Ctrl-K to capture
the query plan allows the SP to complete, but saving the
plan is the problem.


SET STATISTICS PROFILE ON is what you are looking for.

You can also use Profiler, and filter for the event
Performance:Execution Plan.

In SQL 2005 you can actually save the graphical plan (in XML format)
from Managment Studio, the replacement for Query Analyzer and Enterprise
Manager.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Sep 13 '05 #2

P: n/a
Thanks, Erland.

Jim

Sep 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.