1

Closed

Plan Cache Detail Link

description

This is a great program! Something like this should be included in "Management Studio". I did find one issue...
 
After clicking on the link to display "Plan Cache" details, the program appears to hang. If I wait long enough the details window does display but during the wait if I click anywhere in the SQL Live window I get a "Program is not Responding" message in the title bar. When using with my SQL Server 2005 instance it takes about one minute for the detail window to appear. If this is normal then there should be some form of wait message displayed.
Closed Nov 18, 2009 at 5:47 PM by glensmall
Fixed in version 1.27

comments

glensmall wrote Nov 9, 2009 at 1:19 PM

Thanks for the feedback.

The issue you describes come from the fact that the query that runs to generate the plan cache details can take a while on servers that have a large cache - and this is mainly due to an outer join to get the execution plan details. The lack of responsiveness is expected (in this version), but you are correct in that I should have put up a wait message.

I am currently working on optimising that link so that you don't have to wait so long, and I will add a wait message also.

CARizzio wrote Nov 9, 2009 at 4:53 PM

Very Good. I mainly wanted to make sure someone knew about it. It appears you already did ;-) Thanks.

glensmall wrote Nov 10, 2009 at 3:55 PM

Justing finishing off verion 1.27, which (hopefully) has this issue addressed. Just putting it through test and if all goes well, I should publish the update within a few days.

Sign in to add a comment