Execution Plan for a long stored proc cuts off. How to view it in SSMS?

Question

I am trying to look at an execution plan for a sproc that has a massive amount of statements, looping, etc... As you can imagine, the execution plan is really long. In fact, SSMS gets confused before the interesting part that I am trying to look at.

enter image description here

Is there anyway to see the entire execution plan?

Btw, using SSMS 2008 to hit SQL Server 2005.

What do you mean, cuts off? There are vertical and horizontal scrollbars. You can also always just view the xml — Brian White, Jun 26 '12 at 20:18
@BrianWhite Note the missing edges in connectors - they don't connect to anything. — AngryHacker, Jun 26 '12 at 20:56

score 2 · Accepted Answer · answered Jun 26 '12 at 18:18

2

Try the free SQL Sentry Plan Explorer. We've made many enhancements to the graphical view and, while you can't always perfect the layout for an obnoxiously large plan, there are several other tabs where you can glean valuable information without having to find it on the graphical display and without having to parse XML.

(Disclaimer: I work for SQL Sentry.)

answered Jun 26 '12 at 18:18

Aaron Bertrand

272,866
37
466
490

Oh, wow. That's an excellent tool. You should charge for it :) – AngryHacker Jun 26 '12 at 20:19

Jimbo · Answer 2 · 2012-08-17T13:55:08.870

1

Also, look at the free SSMS Tools, it has the ability to take a snapshot of the entire plan.

www.ssmstoolspack.com

edited Aug 17 '12 at 13:55

answered Jun 26 '12 at 19:17

Jimbo

2,529
19
22

Execution Plan for a long stored proc cuts off. How to view it in SSMS?

2 Answers2