Post reply

Execution Plans - Printing

  • July 16, 2010 at 9:08 am

    #226843

    I am doing some performance monitoring on an application which has been developed for us. Some of the queries running are very complex when running an execution plan. Their complexity means it is very difficult to review in the window. Is there anyway of printing this ?

  • July 16, 2010 at 9:33 am

    #1194180

    file > print ?

  • July 27, 2010 at 7:10 am

    #1198677

    Sorry for the delay. I should have said that file - print of course would print it out but the complexity of the execution plan means it prints on over 40 pages and is sort of useless. Is there any other way ?

  • July 27, 2010 at 2:11 pm

    #1198955

    You can also use SET SHOWPLAN_TEXT ON option instead of graphical view.

  • July 27, 2010 at 2:51 pm

    #1198982

    Do you have a plotter available?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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