HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Comparing two XML query plans

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
comparingqueryxmltwoplans

Problem

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!

Solution

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

Context

StackExchange Database Administrators Q#1965, answer score: 4

Revisions (0)

No revisions yet.