why no Plan Diagram display under execution plan

Sarah 2017-01-27 21:28:31

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.


Aaron Bertrand 2017-01-27 21:39:30
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.