November 22, 2011 at 1:20 pm
Anyone have a good way to view and compare execution plans? The display in SSMS is small and I can't view them side by side. Is there a free tool for displaying the ones saved as XML?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 22, 2011 at 1:53 pm
Stefan Krzywicki (11/22/2011)
Anyone have a good way to view and compare execution plans? The display in SSMS is small and I can't view them side by side. Is there a free tool for displaying the ones saved as XML?
Nope. EDIT: Not that I knew of. Thanks Lowell[/EDIT] You can save/reload the plan in a new window though full-sized but that doesn't deal with the side-by-side review unless you fire up a couple of SSMS instances (which is what I usually do).
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 22, 2011 at 1:57 pm
Stefan Krzywicki (11/22/2011)
Anyone have a good way to view and compare execution plans? The display in SSMS is small and I can't view them side by side. Is there a free tool for displaying the ones saved as XML?
I've been using SQL Sentry Plan Explorer, which has a has a free lite version, as well as a free SSMS plug in so you can right click...View plan in SQL Sentry
it has a nicer more compact format than SSMS's plans, so it's alittle easier to read.
the freebie part is to encourage you to buy the full version, which has a lot more tools.
Lowell
November 22, 2011 at 2:02 pm
Stefan Krzywicki (11/22/2011)
Anyone have a good way to view and compare execution plans? The display in SSMS is small and I can't view them side by side. Is there a free tool for displaying the ones saved as XML?
You can use SSMS to open the saved ones. When I compare I use the tab groups functionality in SSMS to compare execution plans. You right-click on the tab and do a new vertical/horizontal tab group.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 22, 2011 at 2:26 pm
I'll either open two windows & bounce between them, or I'll open two instances of SSMS.
SQL Sentry's Plan Explorer is worth checking out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2011 at 2:35 pm
I haven't played with 2012 yet, but do the tabs float like in VS 2010 so you can have each tab on a separate monitor? That might be reason enough to upgrade to the 2012 tools.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 22, 2011 at 2:52 pm
Jack Corbett (11/22/2011)
I haven't played with 2012 yet, but do the tabs float like in VS 2010 so you can have each tab on a separate monitor? That might be reason enough to upgrade to the 2012 tools.
I don't have multiple monitors set up, but yeah, the tabs tear right off like in VS 2010. In theory you'll be able to set it up how you like when we finally get to SQL SErver 2012.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply