Take the 2-minute tour ×
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.

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!

share|improve this question
add comment

2 Answers 2

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
1  
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
1  
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
add comment

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
add comment

Your Answer

 
discard

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.