Free SQL Server Query Plan Analysis, Right In Your Browser
One of my goals when I first started putting together the Performance Studio application was to make it available as a standalone web tool.
It turned out to be way easier than I thought it was going to be, and now you can use it here.
You can either paste plan XML, or upload an execution plan, and all of the analysis that would take place in Performance Studio happens client-side in you browser.
Why? Because it seemed like a nice thing to do for the community. Not everyone can download and run new applications when they want, but they should be able to get quality plan analysis done when they need it.
Client Side?
Yes, client side. By default, I didn’t want any plans to get uploaded to me.
I don’t need to hoard XML, and I don’t want to get random emails asking me to delete or remove things.
This was built to work without having to store files anywhere. Yay.
You can even export the HTML results of the analysis to use in whatever HTML-y ways you want. I don’t care.
There is an option to share, but you have to choose it, consent to it, and choose a TTL on the plan (1 day to 1 year, with some stops in between). There’s even a delete button, in case you go through all that blissfully unaware of your actions. In which case, you should probably unplug.
But anyway, the whole point is that your query plan doesn’t go anywhere unless you want it to. It does not get fed into AI anywhere, nor does it persist anywhere after you close your browser tab. And it sure as heck doesn’t end up on my server.
Do You Collect Anything?
Only some vanity metrics about page views and plans shared. But really just the bare minimum to see how much people are using it.
I have no use for your IP address, to feed you cookies, or to know where you’re visiting from geographically.
If you choose to share a plan with my website, your plan gets stored in a pretty well locked down cloud hosted environment, and only for as long as you choose to leave it there. I’m not, like, daring hackers to try to hack me, but I’ve taken all the precautions I can to make sure your XML stays safe as long as I have it.
Your plans are also not really discoverable in any real way, unless and until you share the link to them. The URLs are all randomly generated, and I don’t expose shared plans in any way. I don’t even look at them, because it’s sort of a pain in the butt for me to look at them.
The next time you need a query plan analyzed, try it out.
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.