Post reply

problem when the estimated execution plan is printed

  • February 14, 2006 at 12:45 pm

    #111395

    Hi,

    With query analyser, I can generate the estimated execution plan of a query BUT when I want to print the execution plan, all the icon doesnt appear at the printer. Only the LINES / Cost / type of join appear  at the printer.

    any idea ?

    thank you

    Danny (alias Calico)

     

  • February 15, 2006 at 5:52 am

    #620983

    printing plans is always a pain - I often grab a screenshot and print that. You could try resizing the plan, right click in the plan window and choose a different zoom.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 15, 2006 at 11:19 am

    #621139

    you are right this is a pain. in the end i just gave up on the printing and use qp on the sceen.

    this is surely for ms to fix, i thought they would do that in sql 2005.

    Everything you can imagine is real.

  • February 15, 2006 at 11:27 am

    #621144

    If I really want to see the plans I use profiler with showplan - mind you can't print that either !!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 17, 2006 at 3:58 am

    #621592

    For printing, the non-graphical showplan is best. Before you run your query in QA, execute the following:

    SET SHOWPLAN_TEXT ON

    SET NOEXEC ON

    Now run your query by pressing F5 or the Execute button. This won't actually run the query, but will just generate a textual version of the showplan instead.

    When you've finished, in order to get any query to run after this (including SET SHOWPLAN_TEXT OFF) you'll need to run SET NOEXEC OFF first.

    Run everything in text mode - this makes it easier to format the output when pasting into a document.

Viewing 5 posts - 1 through 4 (of 4 total)

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