SQL Server Performance

Management Studio Execution Plan and Tuning

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by gryphonsclaw, Oct 24, 2006.

  1. gryphonsclaw New Member

    I am trying to get used to Management Studio and my biggest frustration is in the execution plan. In query analyzer you could right click a table in the execution plan and update statistics or create an index. Where did this go? It's a pain to scroll through tables in the object explorer. AM I missing a button or menu option?

    Thanx,



    Thanx
    Adam
  2. satya Moderator

    See this BOL text helps:
    quote:
    Open or type a Transact-SQL script that contains the queries you want to analyze into the Management Studio query editor. After the script has been loaded into the Management Studio query editor, you can choose to either display an estimated execution plan or the actual execution plan by clicking the Display Estimated Execution Plan or the Include Actual Execution Plan button on the query editor toolbar. If you click Display Estimated Execution Plan, the script is parsed and an estimated execution plan is generated. If you click Include Actual Execution Plan, you must execute the script before the execution plan is generated. After the script is parsed or executed, click the Execution Plan tab to see a graphical representation of execution plan output.


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. gryphonsclaw New Member

    K, I do that but I can't right click the graphical objects in the execution plan anymore to create indexes or update statistics on that object (table) like I could in query analyzer.

    Thanx
    Adam
  4. jezemine New Member

    that feature is gone from showplan in SSMS. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br /><hr noshade size="1">SqlSpec - a fast, cheap, and comprehensive data dictionary generator <br />for SQL Server 2000 and 2005 and Analysis Server 2005 - www.elsasoft.org <br />
  5. satya Moderator

    True and you need to adopt new measure in SSMS with SQL 2005.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  6. gryphonsclaw New Member

    Bummer, I really liked that feature.

    Thanx
    Adam

Share This Page