Post reply

Saving Execution Plan

  • October 24, 2006 at 9:03 am

    #170845

    i am trying to save the Actual Execution Plan in SQL Server management Tools but the "Save Execution Plan As..." button is greyed out.

    how to i get around this?

  • October 24, 2006 at 9:05 am

    #667609

    Click anywhere on the plan.  Right click on the plan again, and this time select save execution plan.

  • October 24, 2006 at 9:09 am

    #667613

    tried that. that is also greyed out

  • October 25, 2006 at 7:56 am

    #667861

    anyone have an answer for this?

  • October 25, 2006 at 8:16 am

    #667870

    Can't help much... don't have 2005 installed here.

     

  • October 25, 2006 at 10:25 am

    #667916

    I can't reproduce the problem, but something I saw a couple days ago at teched might help you.

    You aren't by any chance connected to a SQL 2000 instance are you? I have a feeling that you can't save the plan from a query against a 2000 server. I can't confirm that, as I only have a 2005 server here.

    If you are querying sql 2005, try the following.

    Set showplan_xml on, then run the query. Save the xml document that's produced as a .sqlplan file.

    The .sqlplan document that management studio saves is identical to the xml query plan that showplan xml produces. (and, incidentally, is the same as the plan available from the dm view sys.dm_exec_query_plan)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 25, 2006 at 11:29 am

    #667936

    oh yes i am connecting a 2000 SQL SEVER.

    that explains it.

    Thanks

Viewing 7 posts - 1 through 7 (of 7 total)

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