Index Analysis Never Completes

entered stored procedure, selected "Get Actual Plan". When I select the "Index Analysis" tab the tool just spins, never completes.

Plan.pesession (1.6 MB)
avatar image By SQLJarhead 76 asked Feb 03 at 03:54 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Feb 03 at 03:57 PM

Is your table partitioned? Are you using the latest build of Plan Explorer? We have an issue logged about this (#28023) that has been fixed in 11.0.84.

avatar image SQLJarhead Feb 03 at 04:46 PM

Hello Mr. Bertrand, Thanks for taking the time to respond.

Yes they are. The table that is partitioned which each statement hits is the tran_detail table.

avatar image Aaron Bertrand ♦ Feb 03 at 04:48 PM

Great, what is the version of Plan Explorer? Have you turned off or ignored prompts to update?

avatar image SQLJarhead Feb 03 at 04:52 PM +

Just used the tool to check for updates, did not find any. I will manually go look.

10|10000 characters needed characters left

1 answer: sort voted first

We have an issue logged about this (#28023) that has been fixed in 11.0.84 - it occurs when the target table has partitioning.

Please update Plan Explorer to the latest version, and the issue should go away.

I would probably contact support to find out why you had to manually seek an update, though; Plan Explorer should have found the latest version and offered it to you.

avatar image By Aaron Bertrand ♦ 1.7k answered Feb 03 at 05:07 PM
more ▼
(comments are locked)
avatar image SQLJarhead Feb 03 at 05:08 PM

I will do that. Thank you.

10|10000 characters needed characters left
Your answer
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

Topics:

x565
x381
x4

asked: Feb 03 at 03:54 PM

Seen: 33 times

Last Updated: Feb 03 at 05:08 PM