Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hopefully a simple one, if I have two (fairly complex, 30-40 node) .sqlplan files (from the same SQL text) what is a good way to compare them side by side? Or just have it tell me what it did differently? Management Studio is being particularly ridiculous about laying them out with vast amounts of whitespace, and it won't let me reformat them to print on a single page even...


share|improve this question
up vote 4 down vote accepted

Give SQL Sentry Plan Explorer a try. I am not sure it does exactly what you are asking about, but it is a great tool and free!

SQL Sentry Plan Explorer

share|improve this answer
Aha, I can run 2 copies of that and tile them top and bottom of my screen to compare, neat! – Gaius Mar 29 '11 at 13:18
Yep, that's the only way I found too :-). – Marian Mar 29 '11 at 13:48
+1 for SQL Sentry Plan Explorer; I've used it for this very thing but I still wish there was a SQL Plan Diff tool :D – Jeff Mar 29 '11 at 16:06

Using a comparison tool like csdiff maybe?

share|improve this answer
Diffing is easy, what I'd like is something that says "the two plans diverged at this node for this reason" or allows me to easily derive that – Gaius Mar 29 '11 at 13:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.