why no Plan Diagram display under execution plan

Hi expert,

I'm exploring your product on our test server and also trying to figure out why this query took so long. The test server doesn't have any data so the slowness didn't reflect in this result.

I looked over your tutorial video and saw there was this nice Plan Diagram under the execution plan which allows you to replay and see where the slowness is and the CPU/IO during each timeframe. Why didn't I see it in my window?

Any insights on how to improve this query is also greatly appreciated.

Thanks, Sarah

Plan.pesession (129.7 kB)
avatar image By Sarah 0 asked Jan 27, 2017 at 09:28 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Jan 27, 2017 at 09:39 PM

I see a Plan Diagram, you need to click on the Plan Diagram tab at the bottom, if you don't see that tab try Window > Reset Window Layout.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: Jan 27, 2017 at 09:28 PM

Seen: 24 times

Last Updated: Jan 27, 2017 at 09:39 PM