Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also use the same and reproduce it on their machine. I realized that I have actually never written on how one can send a graphical execution plan to another user so that they can reproduce the same exact details without all the actual tables, indexes and objects.
Here is very simple method on how one can do that.
Right Click on Execution Plan and click on “Save Execution Plan As…”.
You can save the plan with the extension .sqlplan. The same plan can be sent to another user via email or a USB drive. Another user can just double click on the file and open the execution plan at another local computer without physically having any underlying object.
This is very simple trick; you can also send the execution plan in text format as well. We will talk about it in some other post.
Reference: Pinal Dave (http://blog.SQLAuthority.com)