Search

Hovering mouse over execution plans query line is CPU killer by Arild Røksund

Closed
as Fixed Help for as Fixed

15
1
Sign in
 to vote
Type: Bug
ID: 360457
Opened: 8/4/2008 1:57:48 AM
Access Restriction: Public
0
Workaround(s)
13
User(s) can reproduce this bug
When running a query and showing execution plan, the original query (and missing index suggestions) is showing on the top. When hovering mouse over, the tooltip box flickers alot and CPU is going up to 60% and staying there until I move the mouse out of the field.
Details (expand)
Product Language
English

Version

SQL Server 2008 Release Candidate 0

Category

Tools (SSMS, Agent, Profiler, etc.)

Operating System

Windows Vista SP1
Operating System Language
US English
Steps to Reproduce
Run a query and include execution plan, change to the execution tab and move the mouse over the top field showing the original query.

See image.
Actual Results
The tooltip flickers and CPU goes up alot!
Expected Results
Only showing the tooltip

Platform

32
File Attachments
File Name Submitted By Submitted On File Size  
ssms execution plan cpu killer.jpg (restricted) Arild Røksund 8/4/2008 -
Hovering.zip (restricted) Arild Røksund 6/17/2009 -
Sign in to post a comment.
Posted by Carl Daniel on 7/28/2011 at 8:33 AM
I can confirm that this is indeed fixed in SQL 2008 R2 SP1. I didn't try CU7 or CU8 - presumably this is fixed in at least one of those as well.
Posted by Microsoft on 3/18/2011 at 2:54 AM
I apologize for the delay in responding to this. We have fixed this issue internally, and should be available in the next available SQL Server 2008 R2 release. The fix that we have made is -- if the query is less than 1000 characters, we would see the full query in the tool-tip. If it is a longer query, you will see the first 1000 characters and an ellipsis (...). One wants to see the full query can see through the properties window.

Given this, I am going to close this issue for now but if you feel that your issue has been not fixed in next SQL Server 2008 R2 release then please reactivate this bug.

If you have any other comments or feeback then feel free to contact me directly at nikhilku@microsoft.com

Thanks,
Nikhil Kumar
nikhilku@microsoft.com
Posted by Carl Daniel on 3/11/2011 at 7:36 AM
As of SQL 2008 R2 CU6 this is still not fixed. If someone from MSFT would please comment on exactly where this is allegedly fixed, I'm sure the whoole community would appreciate it.
Posted by dwtest on 3/4/2011 at 11:14 AM
I have experienced this behavior in SSMS 2008, 2008 R2, and now Denali CTP1
Posted by Kevin Eckart on 9/22/2010 at 1:18 PM
I have been able reproduce this behavior in instances where there is no missing index hint. My particular problem stems from running a stored procedure "exec xxxxx" and including the actual execution plan. Whenever I hover over the text of the SP in the execution plan, my processor spikes to 100% while SSMS itself spikes to 50% (nothing moves higher than 50% during this process). If I save the .sqlplan file, close and reopen ssms, I get the same behavior. Interesting to note that when the text balloon finally does come up, sometimes it will span two screens and other times it will stay on one (this is on the same text).

Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools 10.0.1600.22
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4927
Operating System 6.1.7600
Posted by Arild Røksund on 8/30/2010 at 6:00 AM
Any news on this?

Still an issue, running 10.50.1600.1.
Posted by Carl Daniel on 5/27/2010 at 12:07 PM
If someone from Microsoft is interested in looking into this, I have a .sqlplan file that is a good illustration. All that's needed to see the slow behavior is to open the .sqlplan file and hover the mouse over the query text. No database connection is required.
Posted by Carl Daniel on 5/27/2010 at 12:00 PM
This problem has been in SSMS since day 1 and has always been easy to reproduce. Today I was working with a query that's about 200 lines of T-SQL with an execution plan that has 64 nodes in the query plan. Simply passing the mouse over the query text above the graphical plan results in a pause of several seconds before a gingantic and useless tooltip is populated. It's useless because it's enormous, and it still holds only a small part of the query text - and badly formatted at that.

I'd suggest limiting the tooltip to displaying only the first few hundred characters of a lengthy query.

Win 2k8R2 x64, 2x XEON 5520, 36Gb of RAM, SQL 2008 Enterprise SP1.
Posted by Kevin Eckart on 5/20/2010 at 11:58 AM
I'm experiencing this same issue. Has there been any resolution on this? I'm running Windows 7 Ent, SSMS 2008 10.0.2531.0. This happens to me when viewing an execution plan, and i mouse over a very large query above the missing index suggestion.
Posted by Arild Røksund on 11/10/2009 at 2:42 AM
Have you guys at Microsoft been able to reproduce this behaviour now?
Posted by Arild Røksund on 10/13/2009 at 3:46 AM
Microsoft: Any news here?

This is really a pain in the .....!!!

If you have a big (for example 100 lines) statement, it can take as long a 5-8 SECONDS to move the mouse from the statement/text editor window to the Execution Plan window.

Remember, this is only when there is a Missing Index information in the "header" of the Execution Plan window.
Posted by Arild Røksund on 6/17/2009 at 2:07 AM
Have this issue on 2008 and Windows7 too, so its nothing wrong with my video drivers. I have uploaded a video now showing the issue.

Notice the CPU load on ssms.exe and the "flickering" of the tooltip in ssms.
Posted by Arild Roksund on 4/22/2009 at 4:51 AM
Have you tested this when the Optimizer suggest a new index? I only get this behaviour when there is a MISSING INDEX.
Posted by Kendra Little on 1/16/2009 at 10:46 PM
I am able to reproduce this as well. The plan is also for a query with a missing index, and the criteria in the query has two long 'in' clauses. The CPU stays elevated (in my case around 50%), the toolbox flickers, and SSMS goes white. I am using SSMS 10.0.1600.22.
Posted by aaronbertrand on 8/5/2008 at 10:03 AM
Sorry, I really tried. I do get weird video artifacts on task manager when it is over top, but I could not make the CPU even squeak:

http://www.aaronbertrand.com/voodoo/mihover.gif
Posted by Arild Røksund on 8/4/2008 at 11:54 PM
Hi, its the ssms.exe process that goes up to 50% and stays there. Actually when I tries some more now, it looks like it only happens with queries that missing index, so under the query in the Execution Plan tab, there is a greeen sentence, "missing index...."
Posted by Microsoft on 8/4/2008 at 7:12 AM
Hi Arild,
    Thank you for your feedback on the CPU behavior you are experiancing. We are not able to reproduce the problem with our release candidate. Can you tell what process is pegging the CPU as you perform the hover operation using Windows Task Manager?
Thank you,
Bill Ramos
Sign in to post a workaround.
© 2012 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement