Recently I had to support a team I was not part of in troubleshooting some performance issues while querying data from SQL Server. Being an external person I also did not have any access to the project infrastructure.

Not being from Microsoft background, I haven’t worked on SQL Server in a long time. So, I applied my experience of working with Oracle and requested for some standard artefacts including the execution plan. What I received for the execution plan was a huge XML dump. Now I didn’t want to install any new tool to visualize the plan so I started to look for a quick fix. I stumbled upon a wonderful GitHub project which did the job for me.

If you have a similar requirements you can also visualize the execution plan by following these simple steps:
1. Download the latest release of the project
2. Unzip the project in a folder
3. Browser to the sample folder



4. Open the upload.html file


5. Browse to the Execution Plan you want to visualize and viola!

Refer to the sample image from the GitHub repository showing how other details can be viewed for each step of the plan.

Refer to the GitHub repository for further details:
https://github.com/JustinPealing/html-query-plan