locked
SMSS 2008 R2 Slow Tooltip RRS feed

  • Question

  • Hello.

    I installed the SQL Server 2008 R2 on m machine, which run Windows 7, 32 bit.

    When open in SMSS a large query (the text is long) and view execution plan, if i hover the mouse about query section in the execution plan tab, the SMSS stop responding for some time... 

    When i hover mouse about operator, the tooltip show normally.

    If the query is small ( i dont know the exactly quantity of characters in query ) the tooltip of query shows normally too.

    The image shows where problems occurs: http://img641.imageshack.us/img641/8822/msdnpostimagem.png

    Someone tell me if exists a hotfix for this problem ? Or workaround ? Thanks !!!


    []s Rodrigo Ribeiro Gomes
    Thursday, July 7, 2011 11:41 AM

All replies

  • I don't know of a hotfix for this (but I have not searched), however there is also this FREE tool:

    http://www.sqlsentry.net/plan-explorer/sql-server-query-view.asp

    FWIW,
    RLF

    Thursday, July 7, 2011 12:34 PM
  • Thanks Russell...

    This tools is very good, i go to use it now....

    But too to use too SMSS and your Query Plan...

     


    []s Rodrigo Ribeiro Gomes
    Thursday, July 7, 2011 1:20 PM
  • HIt F4 to view properties and click on the operator, you will get more info than the hover balloon.  
    Thursday, July 7, 2011 6:58 PM
  • Hi gao.seng.

     

    My problem is not occurs in the operator tooltip.

    But in the Tooltip that appears when you hover mouse about section entitled "Query X:", that shows the entire query which that generated plan is for.

     

    Thanks


    []s Rodrigo Ribeiro Gomes
    Friday, July 8, 2011 2:14 PM