3

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...

Thanks!

2 Answers 2

4

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

3
  • 1
    Aha, I can run 2 copies of that and tile them top and bottom of my screen to compare, neat!
    – Gaius
    Mar 29, 2011 at 13:18
  • 1
    Yep, that's the only way I found too :-).
    – Marian
    Mar 29, 2011 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, 2011 at 16:06
0

Using a comparison tool like csdiff maybe?

1
  • 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, 2011 at 13:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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