Execution Plans

  • sizal0234

    SSCrazy

    Points: 2041

    Hi,

    How do  you share execution plans.  Save the plan and share the .sqlformat file as take a screen shot what is the best practice. The only reason to do this to optimize the query.

    Thanks!

  • MVDBA

    SSC-Insane

    Points: 20802

    depends on who you are sharing it with but I use showplan_XML

    https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-xml-transact-sql?view=sql-server-2017

    you can then copy and paste the XML

     

    MVDBA

  • sizal0234

    SSCrazy

    Points: 2041

    Thanks, I guess the path is diff compared to what they mentioned for 2012

    '\Microsoft SQL Server\130\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsd'

     

  • Sue_H

    SSC Guru

    Points: 90260

    When you are viewing the Execution plan, you can right click on the execution plan window, select Save Execution Plan As...and save it as an sqlplan file. Others can open the file with SSMS.

    Sue

  • TUellner

    SSCrazy

    Points: 2371

    You can also use Paste The Plan on Brent Ozar's site. I believe Erik Darling wrote it.

    https://www.brentozar.com/pastetheplan/

    Right-click on your execution plan and show the XML. Copy and paste that into the website. It will show the plan and give you a link to that plan that you can then share with someone else. For instance:

    https://www.brentozar.com/pastetheplan/?id=BkTqPRPwH

    will show the plan that was generated when I ran:

    SELECT * FROM sys.databases AS d WHERE d.database_id < 6

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

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