Display Query Execution Plan - SQL Server 2005

  • How to Display Query Execution Plan (SQL Server 2005) in PDF Format or some other format??? What are the Tools available?

    Please let me know, if any body knows...!!!

    Thanks,

    Yugandhar

  • In 2005 you can save the exec plans in xml formal (.sqlplan). you can open a sqlplan file in management studio to see the whole graphical 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
  • AFAIK, only Management Studio can view query plans. As Gail mentioned, they can be saved, but the data is only in the XML file (sqlplan) or shown in SSMS.

    You can always capture a screen shot if you need basic stuff.

Viewing 3 posts - 1 through 2 (of 2 total)

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