Execution Plans

Question

Post reply

Execution Plans

sizal0234

SSCrazy

Points: 2272
More actions
September 18, 2019 at 3:38 pm

#3681128

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!

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

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

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 1

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: 2272 More actions · Answer 2

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: 90860 More actions · Answer 3

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

Tom Uellner SSCrazy Points: 2995 More actions · Answer 4

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