I want to convert a SQL Server execution plan (sqlplan) to a graphics file so that it can be easily shown to others. I could not find a utility to convert a sqlplan file to an image file. Is there a utility that I missed that can be used to convert a sqlplan file to an image file?
I am also familiar with the idea of using CTRL-Print Screen to copy an image of a window to the paste buffer and then using a graphics utility like Microsoft Paint to save the image as a graphics file. However, It saves the entire window. I have noticed other posts here that manage to just show the execution plan without anything else (like the SSMS clutter) and was wondering if there is an easy way to do that without editing the image.
SET SHOWPLAN_ALL ON
File->Print
in SMSS. Set printer to MSXPS Document Writer
and output to landscape (also in theProperty->Advanced
settings dialogue I set the page size toE size sheet
). Then in my right-click context menu I have an option to convert to Adobe PDF. I did that. Then I opened the PDF in GIMP2, inImage
orLayer->autocrop
andFile->Export As
a GIF.