How to Send Execution Plan in Email? – Interview Question of the Week #079

A few days ago, I sent emails to everyone who subscribed to my newsletter (if you have not subscribed, you are missing out some real fun) that they can send me one performance problem of theirs like and I will help them solve it in 24 hours. I received over 1082 responses in the first 24 hours and honestly, I could not keep my commitment to reply each in 24 hours (even though I answered emails for 18 hours straight). It took me over 4 days to respond to EVERY SINGLE EMAIL, and on the top of it, I was still getting more emails. Finally, I caught up with everything on the fifth day and I had received a total of 2187 performance problems in the email. I have responded to each of them. During this marathon of answering emails, I saw that many users do not know how to send the execution plan in an email.

Question: How to send Execution Plan in Email?

Answer: It is very easy to send Exectuion Plan in Email.

First execution your query by Enabling Actual Execution (Shortcut: CTRL + M).

How to Send Execution Plan in Email? - Interview Question of the Week #079 execplanemail1

Solarwinds

Next right click on the execution plan and select “Save Execution Plan As…”

How to Send Execution Plan in Email? - Interview Question of the Week #079 execplanemail2

After that, just save, plan with the default extension (.sqlplan).

How to Send Execution Plan in Email? - Interview Question of the Week #079 execplanemail3

Next send the file to anybody in the email.

How to Send Execution Plan in Email? - Interview Question of the Week #079 execplanemail6

The user will just have to double click on the file and if he/she has installed SQL Server Management Studio, the plan will automatically open in SSMS.

How to Send Execution Plan in Email? - Interview Question of the Week #079 execplanemail4

The best part is that when another user opens Execution Plan, he/she does not have to have those databases and data installed on his computer. The execution plan will accurately render without any data or database.

How to Send Execution Plan in Email? - Interview Question of the Week #079 execplanemail5

Isn’t this easy? Next time when I will receive any such questions, I am going to point them to this blog post.

Meanwhile, if you have a performance problem with your server, I can help you solve it.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
,
Previous Post
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Next Post
How to Change Fill Factor in SQL Server – Interview Question of the Week #080

Related Posts

Leave a Reply

Menu